Send pdf to email addresses separate

[Mikki]

Good Day~
I want to send an email to each division with a pdf attachment. I have output each division's report into a folder but now I don't know how to send each one to each division's email address and attach each of their report. I want to send one email with pdf to one email address separately.

 

[pr2-eugin]

Recordset looping, Email from Access VBA are some of the keywords that you would use in Google search to get this accomplished.

Some starters:
http://www.utteraccess.com/wiki/index.php/Recordsets_for_Beginners
http://www.rondebruin.nl/win/s1/outlook/mail.htm

 

[Mikki]

Thank you. I am working with Access is it the same code?