Merge records with Mail

[Nuno Guerra]

Hi! I wan't to merge records from a table to the microsoft outlook. The
result is one draft for each table record that contains the email address.
Each record as also a subject and text that it will be post in each email
draft.

How can i do it with code?

 

[Arvin Meyer [MVP]]

Hi! I wan't to merge records from a table to the microsoft outlook. The
result is one draft for each table record that contains the email address.
Each record as also a subject and text that it will be post in each email
draft.

How can i do it with code?

Have a look at the following code:

http://www.datastrat.com/Code/MultipleEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Nuno Guerra]

hi thank you for your answer, but I seem to have some problems.

I paste the code from the link, and when i run it makes this error:
Compile error: User-defined type not defined
"Dim objOutl As Outlook.Application"

Would tou give me more help?

 

[Arvin Meyer [MVP]]

You need to set a reference to your version of Outlook. Tools ... References
then pick your verdion og Outlook from the list.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access