E Mail from Customers Form ! Code does not work, Why ?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I wanted it to just fill in the customers e mail address and the subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"
 
Dave Elliott said:
I wanted it to just fill in the customers e mail address and the subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"
Click to expand...

I don't know what you're doing with strEMail, but the brackets are wrong on your
SendObject statement.

DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"
 
What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



[QUOTE="Rick Brandt"]
[QUOTE="Dave Elliott"]
I wanted it to just fill in the customers e mail address and the subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"[/QUOTE]

I don't know what you're doing with strEMail, but the brackets are wrong on your
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
 
If you want to use "mailto", try it this way:

strEmail = "mailto:" & Me.[E Mail]
Application.FollowHyperlink Address:=strEmail


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



[QUOTE="Rick Brandt"]
[QUOTE="Dave Elliott"]
I wanted it to just fill in the customers e mail address and the subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"[/QUOTE]

I don't know what you're doing with strEMail, but the brackets are wrong on your
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
[/QUOTE]
Click to expand...
 
[email protected]#http://dontgetshocked@h

This is what it puts in my Mail To field, it does however open up outlook
express instead of going to a internet site.

Any further suggestions ?

Thanks,



Dave





Cheryl Fischer said:
If you want to use "mailto", try it this way:

strEmail = "mailto:" & Me.[E Mail]
Application.FollowHyperlink Address:=strEmail


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



[QUOTE="Rick Brandt"]
I wanted it to just fill in the customers e mail address and the subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"

I don't know what you're doing with strEMail, but the brackets are[/QUOTE] wrong
on your[QUOTE]
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
 
Change your field type from HyperLink to Text. On your form, you can format
it to underline and display in blue so that it looks "clickable".

If you want to leave the field as type = HyperLink, you will need to open
your table and, for each email address, right click the field value which
brings up a menu. The last menu option is "Edit Hyperlink"; select that and
at the bottom of the Edit Hyperlink window, look for the combo box at the
bottom of the window labeled "Address". It will say:

http://[email protected]

Change this to:

mailto:[email protected]

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

Dave Elliott said:
[email protected]#http://dontgetshocked@h

This is what it puts in my Mail To field, it does however open up outlook
express instead of going to a internet site.

Any further suggestions ?

Thanks,



Dave





Cheryl Fischer said:
If you want to use "mailto", try it this way:

strEmail = "mailto:" & Me.[E Mail]
Application.FollowHyperlink Address:=strEmail


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



I wanted it to just fill in the customers e mail address and the
subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"

I don't know what you're doing with strEMail, but the brackets are wrong
on your
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
And, if you do change your field from HyperLink to Text, you will need to
edit the stored value which now is visible to remove the
#http://email_address.com



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
[email protected]#http://dontgetshocked@h

This is what it puts in my Mail To field, it does however open up outlook
express instead of going to a internet site.

Any further suggestions ?

Thanks,



Dave





Cheryl Fischer said:
If you want to use "mailto", try it this way:

strEmail = "mailto:" & Me.[E Mail]
Application.FollowHyperlink Address:=strEmail


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



I wanted it to just fill in the customers e mail address and the
subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"

I don't know what you're doing with strEMail, but the brackets are wrong
on your
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Thanks, Cheryl, I figured that out. e-mail working fine. Thank You
Cheryl Fischer said:
And, if you do change your field from HyperLink to Text, you will need to
edit the stored value which now is visible to remove the
#http://email_address.com



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
[email protected]#http://dontgetshocked@h

This is what it puts in my Mail To field, it does however open up outlook
express instead of going to a internet site.

Any further suggestions ?

Thanks,



Dave





Cheryl Fischer said:
If you want to use "mailto", try it this way:

strEmail = "mailto:" & Me.[E Mail]
Application.FollowHyperlink Address:=strEmail


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



I wanted it to just fill in the customers e mail address and the
subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast Electric"

I don't know what you're doing with strEMail, but the brackets are wrong
on your
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Glad to hear it!

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
Thanks, Cheryl, I figured that out. e-mail working fine. Thank You
Cheryl Fischer said:
And, if you do change your field from HyperLink to Text, you will need to
edit the stored value which now is visible to remove the
#http://email_address.com



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Dave Elliott said:
[email protected]#http://dontgetshocked@h

This is what it puts in my Mail To field, it does however open up outlook
express instead of going to a internet site.

Any further suggestions ?

Thanks,



Dave





If you want to use "mailto", try it this way:

strEmail = "mailto:" & Me.[E Mail]
Application.FollowHyperlink Address:=strEmail


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

What is wrong with code ? Dont want to send to Internet, just Outlook
Express.

Dim strEmail As String
Hyperlink = False
strEmail = "mailto:" & Me.[E Mail]
'DoCmd.SendObject , , , Me., , , "From Gulf Coast Electric"



I wanted it to just fill in the customers e mail address and the
subject.
Using Outlook Express.

Dim strEmail As String

strEmail = "mailto:" & Me.[E Mail]
DoCmd.SendObject , , , [Me.Email], , , "From Gulf Coast
Electric"

I don't know what you're doing with strEMail, but the brackets are
wrong
on your
SendObject statement.

DoCmd.SendObject , , , Me.[Email], , , "From Gulf Coast Electric"
[/QUOTE]
[/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top