Using a macro to send an object to a variable e-mail address.

[T.Amundsen.III]

I am trying to get my database to send one of its records to an e-mail
address which is one of the fields of the record. There seems to be no way to
set the "TO" field to anything but an actual e-mail address. Does anyone know
a relatively simple way around this?

 

[Thomas C Amundsen III]

Problem solved.

 

[Steve Schapel]

T.Amundsen.III,

If you have a form open, and sending the email to the current record on
the form, you can use this in the To argument of your SendObject macro
action...
=[Forms]![NameOfForm]![EmailAddress]

 

[Steve Schapel]

So, what did you come up with?

 

[Thomas C Amundsen III]

Came up with exactly the same thing you posted, somebody had already actually
asked the question, just took me a litle while to find it.