var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sending a Newsletter
Is there anyway that I can send a newsletter through Access.
A client has a travel agency that he wants to send a newsletter to customers that are in his address book that is in his Access db.
Newsletter via email, I assume?
You'll need to loop through the email addresses and use the SentTo or OutputTo commands (at least, that's what I think they're called from memory) to send the message data.
Yes it would be through email. The point is that I am not to sure of the code that could gather the addresses and send the email newsletter
SELECT EmailAddress FROM tblCustomer
the code that could gather the addresses
Look up the help for DoCmd.SendObject
send the email newsletter
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
Could anyone give me an example of the code that could be used to select the email address and include an attachment (report) to be send?