Using Outlook, Word and Access to send bulk emails.

[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.