Access - Outlook

[Peter]

Hi ,
From an command button in Access form1 I want to open and populate the
following in a Outlook Email

From: = Form1.Textfield1
To = Form1.textfield2
CC= Form1.textfield3
Subject line: Form1.textfield4

Thanks!

 

[Michael Bauer [MVP - Outlook]]

Add a reference to the Outlook object model to your Access VBA project
(Tools/References) in order to be able to see/learn the object model.

You can create an item with the CreateItem function. For an email the
function returns a MailItem object.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>


Am Fri, 16 Apr 2010 10:24:01 -0700 schrieb Peter:

 

[Peter]

Thank you Mr.Bauer, much appriciated!

Add a reference to the Outlook object model to your Access VBA project
(Tools/References) in order to be able to see/learn the object model.

You can create an item with the CreateItem function. For an email the
function returns a MailItem object.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>


Am Fri, 16 Apr 2010 10:24:01 -0700 schrieb Peter:

.