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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]
 
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.
 
Back
Top