Access - Outlook

  • Thread starter Thread starter Peter
  • Start date Start date
P

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!
 
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:
 
Thank you Mr.Bauer, much appriciated!

Michael Bauer said:
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:

.
Click to expand...
 
Back
Top