sendobject macro

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

Guest

I am trying to create a macro that e-mails information from a form to a
specified recipient included on the form. The macro currently attaches the
form to the e-mail but I can not figure out how to populate the "To" line
with the recipient listed on the form.
 
Thanks for your help, I'm now one step closer...

How about attaching two fields from the same form in the Subject Line?
=[Forms]![NameOfForm]![Name] and =[Forms]![NameOfForm]![Id number]

I have tried the above syntax 20 different ways...


Steve Schapel said:
Pants,

=[Forms]![NameOfForm]![EmailAddress]

--
Steve Schapel, Microsoft Access MVP

I am trying to create a macro that e-mails information from a form to a
specified recipient included on the form. The macro currently attaches the
form to the e-mail but I can not figure out how to populate the "To" line
with the recipient listed on the form.
Click to expand...
Click to expand...
 
Pants,

Was this one of the 20 ways?...
=[Forms]![NameOfForm]![Name] & [Forms]![NameOfForm]![Id number]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending E-Mails Using Macros - Populate To and CC 2
Access 2007 Macros - SendObject action, Message Text action argume 8
Sendobject macro 1
SendObject 2
SendObject in Macro Fails Second Time Through 2
SendObject - Two Email pages 4
Macro SendObject Text 7
Automatically enter E-mail address in To: diesl of SendObject Mac 2

Back
Top