Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft Access

Status
Not open for further replies.

060159

Technical User
Feb 19, 2004
54
GB
I want to create a macro so that access will open up outlook and put the email address in of the person whose record is on the screen-is there an easy way to do this? Thanks in anticipation
 
Hi 060159,

Yes you can do this using the Microsoft Outlook Object library and create an instance of outlook. Do you know much VBA? I have seen examples of how to use this library posted here do a search for some code but basically you with the Outlook instance(object) you can create a new email with the subject and body you want and sent it (or save it as a draft) to whomever you wish.

A,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top