sherylnance
New member
- Local time
- Today, 04:07
- Joined
- Jan 12, 2007
- Messages
- 9
Hi All,
I am creating individual files from my access database to be distibuted to 75 different people. I have the file creation automated and would like to incorporate the email distribution in this process. Does anyone have a suggestion as to how I should go about doing this? I am using Access 2003 and Outlook 2003.
psuedo code: (access module)
locNme = select location_name from location
EmailRcp = Select emailAddr from location where location name = locNme
loop
build file
email file
end loop
Any thoughts?
Thanks in advance for every suggestion!
I am creating individual files from my access database to be distibuted to 75 different people. I have the file creation automated and would like to incorporate the email distribution in this process. Does anyone have a suggestion as to how I should go about doing this? I am using Access 2003 and Outlook 2003.
psuedo code: (access module)
locNme = select location_name from location
EmailRcp = Select emailAddr from location where location name = locNme
loop
build file
email file
end loop
Any thoughts?
Thanks in advance for every suggestion!