Double Click fax/email

S

serviceenvoy

I have a fax service that allows me to fax via email. I just have to
enter this in the "TO" line of my email:
[email protected].

I currently have a double click feature set up to create emails which
is the following:
Dim strEmail As String
strEmail = "mailto:" & Me.[Email_1]
Application.FollowHyperlink Address:=strEmail

What I would like to do is modify this so I can double click a fax
number and have it create a new email message and automatically create
the following to line: [email protected]. How do I
modify my formula to do that?
 
S

Scott McDaniel

I have a fax service that allows me to fax via email. I just have to
enter this in the "TO" line of my email:
[email protected].

I currently have a double click feature set up to create emails which
is the following:
Dim strEmail As String
strEmail = "mailto:" & Me.[Email_1]
Application.FollowHyperlink Address:=strEmail

What I would like to do is modify this so I can double click a fax
number and have it create a new email message and automatically create
the following to line: [email protected]. How do I
modify my formula to do that?

Try this:

Dim strEmail As String
strEmail = "mailto:[email protected]"
Application.FollowHyperlink Address:=strEmail



Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
S

serviceenvoy

I have a fax service that allows me to fax via email. I just have to
enter this in the "TO" line of my email:
[email protected].
I currently have a double click feature set up to create emails which
is the following:
Dim strEmail As String
strEmail = "mailto:" & Me.[Email_1]
Application.FollowHyperlink Address:=strEmail
What I would like to do is modify this so I can double click a fax
number and have it create a new email message and automatically create
the following to line: [email protected]. How do I
modify my formula to do that?

Try this:

Dim strEmail As String
strEmail = "mailto:[email protected]"
Application.FollowHyperlink Address:=strEmail

Scott McDaniel
scott@takemeout_infotrakker.comwww.infotrakker.com

No, that doesn't work. It created a new email and in the to line it
literally said "[email protected]". I need it to insert
the fax number field in front of the @metrohispeed.com. Any idea how
to do that?
 
S

serviceenvoy

I have a fax service that allows me to fax via email. I just have to
enter this in the "TO" line of my email:
[email protected].
I currently have a double click feature set up to create emails which
is the following:
Dim strEmail As String
strEmail = "mailto:" & Me.[Email_1]
Application.FollowHyperlink Address:=strEmail
What I would like to do is modify this so I can double click a fax
number and have it create a new email message and automatically create
the following to line: [email protected]. How do I
modify my formula to do that?

Try this:

Dim strEmail As String
strEmail = "mailto:[email protected]"
Application.FollowHyperlink Address:=strEmail

Scott McDaniel
scott@takemeout_infotrakker.comwww.infotrakker.com

I haven't heard back from you. The solution you suggested didn't
work. Please reply.
 
Top