D
DoctorV3774 via AccessMonster.com
I have a table in Access named Tbl_Persons. This table has 4 fields
Code
EMail_Address
Person
Path
When I click a button I want the module to do the following.
Send an E-Mail to each email address with an attachment based on the path and
place in the subject the Field Person Value plus the words Report
Example Records in Tbl_Person
I have 1 for code, (e-mail address removed) for EMail_Address, John Doe as Person, C:\
MyWordReport.doc as Path
I need the code to email to (e-mail address removed) the attachment C:\MyWordReport.doc
and in the subject say John Doe Report
THEN go the next record and do the same until all the records are complete.
How can i do this? Thanks
Code
EMail_Address
Person
Path
When I click a button I want the module to do the following.
Send an E-Mail to each email address with an attachment based on the path and
place in the subject the Field Person Value plus the words Report
Example Records in Tbl_Person
I have 1 for code, (e-mail address removed) for EMail_Address, John Doe as Person, C:\
MyWordReport.doc as Path
I need the code to email to (e-mail address removed) the attachment C:\MyWordReport.doc
and in the subject say John Doe Report
THEN go the next record and do the same until all the records are complete.
How can i do this? Thanks