send an email

[peterbowles]

I want to click a button on a form and it opens my email program and inserts all the email address (email address field ) into the TO: field, or if it is possiabe to insert them into the BCC so the recipent can not see the other email address.

Stuck on this one so any help would be great

thanks

 

[ColinEssex]

DoCmd.SendObject

Col

 

[peterbowles]

ok cheers,

I can send an email to a single user .

I have created a qry that pulls all the email address out of the records. so can I do the following

in the BCC field on the docmd.sendobject can I type the name of my qry and it will use all those address?

 

[ColinEssex]

I've not done emails to multiple users. I would imagine (and I'm only guessing) you may have to loop through the query and append each email address to a string variable then seperate them with a ; (semicolon) then use the variable in the SendObject BCC part.

I seem to remember Hayley doing something on emails a year or so ago. Have a search to see if you can uncover anything.

Col