Access-Outlook

[Peter]

Hi, i posted this question previously in the Outlook forum and realised
perhaps it the wrong place to ask this question...


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!

 

[Arvin Meyer [MVP]]

Have a look at:

http://www.datastrat.com/Code/OutlookEmail.txt

 

[Peter]

Much appreciated Mr. Meyer...if I may inquire further,

Form1 displays a query result were all textfields as editable, this way the
user can make amendments prior to populate the email and these amendments are
stored in the current query session as a unique record.

The email is a template were the body is predefined but for the hyperlinks
<1> and <2> and the name of the template is displayed in Form1 textfield10...
1. Hyperlinks <1> and <2> are related to Form1 textfield 11 and 12. How do
I populate them in the same commend
2. I want to use the If statement to “pick†up the template i.e.
If!Me[Textfield10] = “template1†Then....?
How do I define the path for this template and how do I “pick†up this
template..

Once again, your effort is much appreciated

Thanks!

 

[Arvin Meyer [MVP]]

You can branch code with an If ... Then ... Else statement. So use something
like:

If Condition1 Then
Do this
Else
Do that
End If
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

Much appreciated Mr. Meyer...if I may inquire further,

Form1 displays a query result were all textfields as editable, this way
the
user can make amendments prior to populate the email and these amendments
are
stored in the current query session as a unique record.

The email is a template were the body is predefined but for the hyperlinks
<1> and <2> and the name of the template is displayed in Form1
textfield10...
1. Hyperlinks <1> and <2> are related to Form1 textfield 11 and 12. How
do
I populate them in the same commend
2. I want to use the If statement to "pick" up the template i.e.
If!Me[Textfield10] = "template1" Then....?
How do I define the path for this template and how do I "pick" up this
template..

Once again, your effort is much appreciated

Thanks!

Have a look at:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access





.

 

[Peter]

Much obliged Mr. Meyer, thank you!

You can branch code with an If ... Then ... Else statement. So use something
like:

If Condition1 Then
Do this
Else
Do that
End If
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

Much appreciated Mr. Meyer...if I may inquire further,

Form1 displays a query result were all textfields as editable, this way
the
user can make amendments prior to populate the email and these amendments
are
stored in the current query session as a unique record.

The email is a template were the body is predefined but for the hyperlinks
<1> and <2> and the name of the template is displayed in Form1
textfield10...
1. Hyperlinks <1> and <2> are related to Form1 textfield 11 and 12. How
do
I populate them in the same commend
2. I want to use the If statement to "pick" up the template i.e.
If!Me[Textfield10] = "template1" Then....?
How do I define the path for this template and how do I "pick" up this
template..

Once again, your effort is much appreciated

Thanks!

Have a look at:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


Hi, i posted this question previously in the Outlook forum and realised
perhaps it the wrong place to ask this question...


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!


.

.