Extracting an E-mail address from Access

[LHolden]

Is it possible to extract just an e-mail address from access, and insert it into the 'To' field in outlook? For example if 'Email Address' were a control on a form, or a report, could code be written to extract just that?

Thanks for any help!

 

[pbaldy]

Sure; one way in VBA code would use DoCmd.SendObject and Me.EmailAddress in the "To" argument. More info in VBA help.

 

[LHolden]

Thanks, but I don't want to send an object, just want to extract the email address from it, but I'll go look/post in VBA.

Thanks again.

 

[Geotch]

Yes, use the macro send email, for the to field use =forms![nameofyourform].[nameofyourfield]

 

[pbaldy]

You don't have to send an object. The code can be used to simply start an email with the address.