Access - Outlook

Status
Not open for further replies.
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!
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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

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

Peter

Thank you Mr.Bauer, much appriciated!

"Michael Bauer " 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
> Category Manager -

> SAM - The Sending Account Manager:
>

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

> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
T Render Outlook emails in MS access as they appear in Outlook Outlook VBA and Custom Forms 2
T Outlook "A program is trying to access Outlook" Using Outlook 3
R How can I access my emails from corrupt offline files of MS Outlook ? Using Outlook 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
O Synchronize safe persons Outlook 2016 -> Outlook Web Access (OWA) Using Outlook 30
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
O Outlook Web Access - how to disable spam filter Using Outlook 6
F Outlook 2016 bulk email from access Outlook VBA and Custom Forms 3
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
T Cannot access outlook.com accounts in Outlook 2016 Using Outlook 1
B Can't expose sender email address when linking outlook to access Using Outlook 3
Diane Poremsky Change Outlook's Programmatic Access Options Using Outlook 0
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
C Merging Word and Access into Outlook Using Outlook 4
I Outlook 2016 and Slow access to Outlook.com IMAP Using Outlook 0
B No permission to access Outlook.pst file Using Outlook 1
Norbert VBA Flag that would indicate the email was sent from Outlook to Access. Outlook VBA and Custom Forms 2
U Cannot access fields at bottom of Outlook 2013 Contact Rec. Using Outlook 1
A Synchronize Access Table with Outlook Calendar Appointments Outlook VBA and Custom Forms 3
L Outlook Data Files command not working in the quick access bar Using Outlook 1
Hudas Hyperlink Saved Outlook Email to MS Access Table Using Outlook 4
Hudas Import Outlook Emails(Inbox) to MS Access as Attachment Using Outlook 1
M How do I access a contact list subfolder in Outlook 2013? Using Outlook 5
K how to Access Outlook Contact Properties Using Outlook 1
M Outlook client macro to web access Using Outlook 1
M Access replicated Outlook (email folders, calendar, contacts, notes) via web Using Outlook 1
R Limiting Outlook Access to Inside Network Only Exchange Server Administration 1
J Outlook and owa access Using Outlook 1
O Can't create new email or access email acounts Outlook 2003 Using Outlook 1
C MAPI to access a 64 bit Outlook from a 32 bit application; or access via ODBC Using Outlook 0
C Synchronize outlook with access Using Outlook 1
A Allow Programmatic Access Outlook 2010 Using Outlook 3
M open outlook calendar from an access form Using Outlook 4
M open outlook contacts in access 2007 form Using Outlook 1
J Unable to access public folders in Outlook 2007 on Exchange 2010. OWA PF works fine Using Outlook 7
R Proof Of Looping Bug in Reading Outlook Inbox From Access? Outlook VBA and Custom Forms 2
R Access Program Only Looping Part Way Through Outlook Inbox Outlook VBA and Custom Forms 2
H Exporting Outlook Forms to Access or Excel Outlook VBA and Custom Forms 2
E Redemption access AppointmentItem Label from outlook Outlook VBA and Custom Forms 6
R Outlook and Access integration using VBA Outlook VBA and Custom Forms 1
K Outlook admin vs individual access (VBA pulling info) Outlook VBA and Custom Forms 1
S Sending Email from Access 2007 through Outlook 2007 using template Outlook VBA and Custom Forms 13
D Outlook 2003 - A program is trying to access e-mail addresses Outlook VBA and Custom Forms 5
G Linking Outlook to Access for Contacts in Access Outlook VBA and Custom Forms 3
R Programming Web Outlook Access Outlook VBA and Custom Forms 3
D "Outlook has blocked access to this form template file. Outlook VBA and Custom Forms 3
S Programming Outlook from MS Access (Inbox) Outlook VBA and Custom Forms 1
E trust access to visual basic project greyed out in outlook 2003 Outlook VBA and Custom Forms 1

Similar threads

Top