command button to send email

J

Jerry Crosby

Somewhere in the past I read how to place a command button on a form that
would send an email message, using one of the fields (i.e., the field with
an email address in it!) in the "TO" field. In fact, I put it on a form and
it's working fine. (Actually, it opens a blank email window in Outlook,
with the address from the form already in the TO field.)

However, now that I want to put it on another form, do you think I could
remember how I did it? NOT!

On the working form, it indicates the hyperlink address is mailto:k. That
"k" has got to be a code for something, as it has no relation to the email
field on the form, but I can't figure it out.

Anyone know how to do this?

Jerry
 
A

Al Camp

Jerry,
I'd have the button OnClick fire off the SendObject function, using the
Email field on the form in the TO argument. SendObject also allows other
variables in an email to be "canned", such as CC, Subject, MessageBody,
etc...
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
A

Al Camp

I was going to say... check out SendObject in help. The syntax and
arguments are very straight-forward.
Good deal...
 

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

Access Automatically Send a notification email once a record is added 0
Access 2007 - How to send a form via email using an email from the database 0
Outlook Creating an Outlook form 2
Using Two Fields on a Form to Select Email Addresses from a Table 7
EMail Command Button Problem 1
generate a confirmation email 2
Sending email from Microsoft Access 2003 2
Emailing multiple reports in Access 0

Top