Double Click fax/email

[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:
(e-mail address removed).

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: (e-mail address removed). How do I
modify my formula to do that?

 

[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:
(e-mail address removed).

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: (e-mail address removed). 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

 

[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:
(e-mail address removed).

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: (e-mail address removed). 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 "(e-mail address removed)". I need it to insert
the fax number field in front of the @metrohispeed.com. Any idea how
to do that?

 

[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:
(e-mail address removed).

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: (e-mail address removed). 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.