How to pass email addresses to an Access macro that is sending ob.

[Guest]

I'm sending Access report objects to a variety of recipients via an Access
macro using the sendobject method. I can't figure out how to pass the email
address of the recipients to the "To:" box on the sendobject action line of
the macro. I'm using Access 2003 and Outlook 2003 to transmit the emails. As
the list of recipients is in the hundreds, and changes by week, having a
static email address embedded in the "To:" line won't work for me. I need to
store the email addresses in a table field and then pass them to the macro
for transmission via Outlook. How can I do this?

 

[Chris Reveille]

First link to the outlook contacts folder through File/Get
external data
Second on your form add a combo box on your form selecting
the email address from the newly created linked table.
Third in the to section of you macro put
=[Forms]![NameOfForm]![NameOfcombobox]An easier way might
be to leave the send to blank i the macro and set the edit
message to yes. You will be able to add the send to from
the email message

Chris