Sending emails from Access

[Don]

am using access 2000 to track consignments to customers (parcel tracking). i
want to automatically send an email at the end of each day to customers that
have provided an email address AND have a consignment going out to them on
that day. the sendobject only permits one mail recipient. can i use code or
expression to tell access to find these particular email addresses and
perform a broadcast to these recipients?
-- /Don

 

[Tom Wickerath]

Hi Don,

DoCmd.SendObject can be used to send a message to multiple users. You just
need to build a semi-colon delimited string of e-mail addresses. If you meant
to say that sendobject only permits one file attachment, then this would be a
correct statement. In that case, here is code that works with Microsoft
Outlook:

http://groups.google.com/group/micr..._frm/thread/544e8606046f3da9/12cec9d74e4ea953


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________