SendObject Method: e-mail to list with VBA

[HenryAnthony]

Hello All,

I wish to use SendObject Method to e-mail to a list. The list is derived from a query of a table of e-mail recipients. Any help on how I should write this code would be appreciated.

Henry

 

[DougP]

see my FAQ
faq181-493
You would want to open a recordset of just th epoeple to e-mail too.
then in a For Next loop get each persons e-mail
example Rst!EMail

and stick that in like so (crude example)

for a = 1 to rst.recordcount

DoCmd.SendObject acSendNoObject, "", acFormatTXT, Rst!EMail, , , "---------HOT ORDER-------", Redinfo, False

next

OK DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[HenryAnthony]

Doug, does "Rst!EMail" represent a variable in you example? If so, do you not need to separate e-amil addresses by a semicolon? How would that be accomplished?

Thanks for your help,

Henry