Sending emails from Access

G

Guest

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
 
G

Guest

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
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending E-Mails Using Macros - Populate To and CC 2
Send Emails Automatically 1
Sending emails from Access 2003 4
Setup to proofread emails by another employee before sending? 2
Help with mail merge 1
Sending Email to multiple recipients 3
How to pass email addresses to an Access macro that is sending ob. 1
Hiding recipient addresses when sending to lot of recipients usingOutlook 2010 4

Top