email from an open form

[judith]

How can i pass a field name over to the sendObject macro
to fill in an email address from a record displayed in a
form or should I be doing this in some other way?

thanks

 

[Cheryl Fischer]

Judith,

In the To property of the Macro, insert the following:

=[Forms]![MyFormsName]![EmailControlName]

hth,

 

[Cheryl Fischer]

Yes, it does, as long as your email client (such as Outlook) is MAPI
compliant. You can check out the SendObject method and its requirements
by opening any code module (press Alt-F11), clicking Help on the menu, and
typing: SendObject in the Answer Wizard.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

does this means that you can send an email directly from access?

----- Cheryl Fischer wrote: -----

Judith,

In the To property of the Macro, insert the following:

=[Forms]![MyFormsName]![EmailControlName]

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

How can i pass a field name over to the sendObject macro
to fill in an email address from a record displayed in a
form or should I be doing this in some other way?