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:

> 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!

Thank you Mr.Bauer, much appriciated!

"Michael Bauer [MVP - Outlook]" wrote:

>
>
> 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:
>
> > 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!
> .
>