Populate Email Address with Choice on Form? 1

[DeLaMartre]

This one has been eluding me for some time. Is there a way to populate an email address according to a name chosen on a form (in a combo box)? I want to be able to click a button on the form and have a report attach to an email that is addressed according to the current choice on the form.

Any help would be greatly appreciated.

Thanks very much,



-Bob in California

 

[PHV]

Take a look at the DoCmd.SendObject method

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DeLaMartre]

Thanks very much for your help, PH!

Regards,

-Bob in California