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

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"
 
R

Rick Brandt

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"
 
D

Dave Elliott

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]
 
C

Cheryl Fischer

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...
 
D

Dave Elliott

[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...
 
C

Cheryl Fischer

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...
 
C

Cheryl Fischer

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...
 
D

Dave Elliott

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...
 
C

Cheryl Fischer

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

E-mail / text field 4
E Mail ,this cant be that hard ? Email from customers form ! 2
Buttons and emails 1
See Code Syntax Below, Change E Mail Body to Subject ? 4
e mail syntax, adjust to Subject instead of message, SEE CODE ! Thanks, 1
Send group email 2
Need help with looping through records to email report 7
Opening an access email by double clicking on a text area 2

Top