Using Outlook, Word and Access to send bulk emails. (1 Viewer)

[Ron Mitchell]

Ive built a membership and register of cars database for a UK classic car club and I now want to produce bulk emails using the address’s stored.

I’m Ok with producing the Access file and merging the data in the word document.

The problem that I’ve been working on for the last day or so is to actually get outlook to send the emails.

The error i was getting is that outlook couldn’t find the Outlook.pst file.

It was looking at he C drive but I eventually found it in my OneDrive.

I know that at this point some of you will be ahead of me but please bear with me.

I discovered that having loaded Outlook on my IPhone and IPad that Microsoft changes the location of the .pst files and puts them om the cloud as they cant be saved on the IPhone or Ipad.

I haven’t been able to get Otlook on my PC to look at my One Drive and I didn’t really want too.

So is there a way to remove Outlook from my IPhone and IPad and get the PC back to looking ant my local drive or another way of keeping Outlook on my Apple devices but getting the PC version just looking at the PC hard drive.

Any other Ideas doe overcoming this issue would be much appreciated.

 

[CJ_London]

what version of outlook are you using? Classic or New? It sounds like the former, but if the latter, it won't be possible.

I use POP/SMTP and it works for me. If you are and you are using Classic, try the following:

close outlook
copy the pst to your C drive - perhaps somewhere within your user profile
Open outlook
go to file>Account settings>account settings
On the email tab, there should be a change folder button
click on that and navigate to the new location

For my Iphone I also set up as POP/SMTP but change the settings to leave messages on the server - any emails I send are copied to my email address so I receive them on my main device. May not be ideal for you, but works for me

 

[Ron Mitchell]

what version of outlook are you using? Classic or New? It sounds like the former, but if the latter, it won't be possible.

I use POP/SMTP and it works for me. If you are and you are using Classic, try the following:

close outlook
copy the pst to your C drive - perhaps somewhere within your user profile
Open outlook
go to file>Account settings>account settings
On the email tab, there should be a change folder button
click on that and navigate to the new location

For my Iphone I also set up as POP/SMTP but change the settings to leave messages on the server - any emails I send are copied to my email address so I receive them on my main device. May not be ideal for you, but works for me

I suspect it not the classic version as I’ve just recently re-installed 365

 

[CJ_London]

you should be able to uninstall New and install Classic. Seem to recall click on the search option on the task bar and type 'classic'. Or google for help on how to do it

But check the date of your pst file on onedrive - check if it is current

 

[Pat Hartman]

you should be able to uninstall New and install Classic.

When you install from scratch, you don't get the option of reverting to Classic.

 

[Mark_]

For the piece on "Send an Email", I use the following code normally

Private Sub Send_Email(pvAddress As Variant, pvSubject As Variant, pvBody As Variant, pvAttachment As Variant)

    Dim EmailApp As Outlook.Application
    Dim NameSpace As Outlook.NameSpace
    Dim Folder As Outlook.Folder
    Dim EmailSend As Outlook.MailItem
          
    Set EmailApp = New Outlook.Application
    Set NameSpace = EmailApp.GetNamespace("MAPI")
    Set Folder = NameSpace.GetDefaultFolder(olFolderInbox)
    Set EmailSend = Folder.Items.Add(olMailItem)
    
    With EmailSend
        .To = pvAddress
        .Subject = pvSubject
        .HTMLBody = pvBody
        .Attachments.Add (pvAttachment)
        .Display
        '.Send  '.send commented out as local config for outlook does not like auto-send.
    End With

    'When finished, release resources.
    Set EmailApp = Nothing
    Set NameSpace = Nothing
    Set Folder = Nothing
    Set EmailSend = Nothing
    
End Sub

This lets you pass the function an address OR group of addresses. This will work with Outlook Classic (Only one that has a .pst file you can access) but requires you to run it from the location you've installed Outlook. If you don't have Outlook Classsic installed where you run Access from, that would require a different approach.

 

[CJ_London]

When you install from scratch, you don't get the option of reverting to Classic

You do have the option to not install new outlook and install classic as described in my post. I did that on my new laptop

 

[June7]

When I installed Office 2021 I had option for Outlook to switch to Classic. New and Classic both show in list of apps. Classic is my default mail app. Even if it isn't, Classic should be there for the CDO code to work with.

I have read recent discussions that MS no longer includes Classic with 365 install. The MS Store download/install for Classic no longer works. I had to download Outlook for Windows to my other PC because Outlook2010 would no longer work. I do get advert emails but no sidebar ads. Outlook automation not possible on this PC.

 

[Gasman]

Install or reinstall classic Outlook on a Windows PC - Microsoft Support

support.microsoft.com

 

[June7]

Yes, that is the download/install I attempted. The MS Store download doesn't work. The other download is for Office 365 I don't want.

 

[Gasman]

Yes, that is the download/install I attempted. The MS Store download doesn't work. The other download is for Office 365 I don't want.

The Store link took quite a while to appear for me. I initially thought it was not working (as well?)

Outlook for Windows (classic) - Download and install on Windows | Microsoft Store

Outlook for Windows (classic) is the desktop app for your email, calendars, contacts, and to-dos in one place. Sign in with your work, school, or personal Microsoft account to get started. A Microsoft 365 Personal or Family subscription is required to use this app with personal accounts. With...

apps.microsoft.com

The above is the UK version.
I cannot see to get a link for the US version, but try US instead of GB?

Yep, this works

Outlook for Windows (classic) - Download and install on Windows | Microsoft Store

Outlook for Windows (classic) is the desktop app for your email, calendars, contacts, and to-dos in one place. Sign in with your work, school, or personal Microsoft account to get started. A Microsoft 365 Personal or Family subscription is required to use this app with personal accounts. With...

apps.microsoft.com

 

[June7]

Every time I click Install, it fails and advises "We couldn't install this product. Wait a bit and try again". So I just installed O365 and Outlook Classic app shows along with Outlook New. Opening Classic tells me this is a trial and I have to buy O365 subscription to continue. For my other PC I bought Office2021 and got Classic that way. I am NOT subscribing to O365 to get Classic. So I will do without on this PC.

 

[Gasman]

Yes, that is the download/install I attempted. The MS Store download doesn't work. The other download is for Office 365 I don't want.

See if this helps at all?

 

[June7]

That video is showing MS Office Professional Plus 2021. As I said, I already installed 2021 for one PC and it is fine, Outlook Classic works. It was a cheap 3rd-party purchase and can't install on a second PC.

My second PC still has Office 2010 and that Outlook is basically dead.
My attempt to obtain Classic via 365 without buying fails.
Opening Outlook Classic advises that MIcrosoft 365 must be purchased.

Registry edits don't seem relevant.

 

[Pat Hartman]

You do have the option to not install new outlook and install classic as described in my post. I did that on my new laptop

I was never given the option to not install new Outlook. in fact, I got no options at all except for the bitness. AND once Office was installed, Access was nowhere to be found. It wasn't given an icon and it wasn't listed in any submenu. I had to "uninstall" Access and then reinstall it. This was a brand new computer with Win 11 and Office had never been previously installed.

 

[June7]

With my Office 2021 Pro Plus, I wasn't given option to not install. After install, when I opened Outlook the New version opened and there was a clickable prompt in upper right corner to "Switch to Classic". Both apps are still listed but now Classic is default.

 

[Pat Hartman]

With my Office 2021 Pro Plus, I wasn't given option to not install. After install, when I opened Outlook the New version opened and there was a clickable prompt in upper right corner to "Switch to Classic". Both apps are still listed but now Classic is default.

Not in my world. Access probably installed correctly for you also.

 

[June7]

Yes, the entire suite of apps installed. Best purchase deal I ever made.

 

[gemma-the-husky]

The other day I realised that all the files in my documents folder C:/users/myname/documents had moved to my OneDrive. I must have clicked something to move them, but I can't think what.