AUTO EMAIL - ACCESS TO OUTLOOK

[damienwjking]

Does anyone know how to get Access to automaticly do an email mail merge, or some way to send a generic email to everyone in an access database????? (using outlook preferably) not asking 4 much hey.

Cheers

 

[nberryman]

Have you checked the FAQs? I am sur there is something on looping through records and Outlook there.

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[damienwjking]

Thanks for that tip. I did find a faq that suits by mdthornton. I placed the module code he had given me and tried to call it from a form but the debugger doesn't like any of the user defind types, i.e.

Dim myO As Outlook.Application

Dim mobjNewMessage As Outlook.MailItem

It comes up with compiler error, user defined type not defined. WOuld you happen to know how to overcome this.

Thanks.

 

[KyleS]

While viewing your module go to Tools-->References--> and check the box next to "Microsoft Outlook 8.0 Object Library" (NOTE: your version number may be different depending on what Outlook you have). Now try to compile. Kyle

 

[wkendrvr]

Depending on the version of Outlook, you might still have problems. Microsoft "broke" a lot of the automation due to the spammer's sending virii. I ended up calling an external mailer and have not had a problem. Might want to take a look at Blat mailer.

 

[damienwjking]

Thanks guys,
Checking the Outlook Object library has worked for me so great news.
cheers