List of e-mail addresses to copy to e-mail

[Ellen]

Hello,
I'd like to be able to retrieve a list of e-mail addresses
with the click of a button on a form. I'd like to be able
to copy these addresses into the "To:" section of an e-
mail. Can anyone help me?

Thanks in advance for your help.

Thanks,
Ellen

 

[Rick B]

Where are these addresses?

You need to use the Docmd.SendObject to create the email.





Hello,
I'd like to be able to retrieve a list of e-mail addresses
with the click of a button on a form. I'd like to be able
to copy these addresses into the "To:" section of an e-
mail. Can anyone help me?

Thanks in advance for your help.

Thanks,
Ellen

 

[Ellen]

Rick,
I have a field devoted to e-mail addresses. I'd like to
have them to display one after the other separated by a
semicolon. I assume that a report would be the best
vehicle.

Is Docmd.SendObject a command used in a macro?