Emailing from Access

  • Thread starter Thread starter Stewart
  • Start date Start date
S

Stewart

Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks
 
Presuming that the field in which you have your email addresses stored is of
Text type, you could put the following in the Click event of your command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
 
That code, while it launches OE, throws a "mailto:" into the field each time
one clicks on the email address...at least in A2003.

Cheryl Fischer said:
Presuming that the field in which you have your email addresses stored is of
Text type, you could put the following in the Click event of your command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

[QUOTE="Stewart"]
Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks[/QUOTE]
[/QUOTE]
Click to expand...
 
Yes. That code is doing what it is designed to do.

If you are testing it and it is opening OE, that is because OE is your
default email software.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

John said:
That code, while it launches OE, throws a "mailto:" into the field each time
one clicks on the email address...at least in A2003.

Cheryl Fischer said:
Presuming that the field in which you have your email addresses stored
Click to expand...
is
of
Text type, you could put the following in the Click event of your command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

[QUOTE="Stewart"]
Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
 
Got it...I didn't read the initial message closely enough. :)


Cheryl Fischer said:
Yes. That code is doing what it is designed to do.

If you are testing it and it is opening OE, that is because OE is your
default email software.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

John said:
That code, while it launches OE, throws a "mailto:" into the field each time
one clicks on the email address...at least in A2003.

Cheryl Fischer said:
Presuming that the field in which you have your email addresses stored
Click to expand...
is
of
Text type, you could put the following in the Click event of your command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Great! Thank you for posting back.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

jwm said:
Got it...I didn't read the initial message closely enough. :)


Cheryl Fischer said:
Yes. That code is doing what it is designed to do.

If you are testing it and it is opening OE, that is because OE is your
default email software.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

John said:
That code, while it launches OE, throws a "mailto:" into the field
Click to expand...
each
time
one clicks on the email address...at least in A2003.

Presuming that the field in which you have your email addresses
Click to expand...
stored
is
of
Text type, you could put the following in the Click event of your command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Yeah, I missed that. How's Houston...I went to grad school at Rice,
sometime in the last century. :)


Cheryl Fischer said:
Great! Thank you for posting back.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

jwm said:
Got it...I didn't read the initial message closely enough. :)


Cheryl Fischer said:
Yes. That code is doing what it is designed to do.

If you are testing it and it is opening OE, that is because OE is your
default email software.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

That code, while it launches OE, throws a "mailto:" into the field each
time
one clicks on the email address...at least in A2003.

Presuming that the field in which you have your email addresses stored
is
of
Text type, you could put the following in the Click event of your
command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Getting a bit cool again - the temp did not get above 70 F. today!!

You went to a FINE school - great history there. (I love their "marching"
band.) Did you watch them in the College Baseball World Series?

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

jwm said:
Yeah, I missed that. How's Houston...I went to grad school at Rice,
sometime in the last century. :)


Cheryl Fischer said:
Great! Thank you for posting back.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

jwm said:
Got it...I didn't read the initial message closely enough. :)


Yes. That code is doing what it is designed to do.

If you are testing it and it is opening OE, that is because OE is your
default email software.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

That code, while it launches OE, throws a "mailto:" into the field each
time
one clicks on the email address...at least in A2003.

Presuming that the field in which you have your email addresses stored
is
of
Text type, you could put the following in the Click event of your
command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Missed the CWS...someone recently told me about it. Inasmuch as I spend
much of my time outside the USA, I didn't know anything about it. They seem
to have done well. :)

Ciao...

jwm


Cheryl Fischer said:
Getting a bit cool again - the temp did not get above 70 F. today!!

You went to a FINE school - great history there. (I love their "marching"
band.) Did you watch them in the College Baseball World Series?

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

jwm said:
Yeah, I missed that. How's Houston...I went to grad school at Rice,
sometime in the last century. :)


Cheryl Fischer said:
Great! Thank you for posting back.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Got it...I didn't read the initial message closely enough. :)


Yes. That code is doing what it is designed to do.

If you are testing it and it is opening OE, that is because OE is your
default email software.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

That code, while it launches OE, throws a "mailto:" into the field
each
time
one clicks on the email address...at least in A2003.

Presuming that the field in which you have your email addresses
stored
is
of
Text type, you could put the following in the Click event of your
command
button:

' Replace with [Your form's control name]
strEmail = "mailto:" & Me.[EMail]
Application.FollowHyperlink Address:=strEmail

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Does anyone know how to take an email address from a field
on a form in Access and automatically enter it into
the "To" field in Outlook.

For instance, if I click a button I want Access open a new
email, get the email address from the relevant field, and
then put that email address into the "To" field.

Any help would be much appreciated.

Thanks
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top