Inserting database fields into email forms

[BT]

Is there a way to insert a database field into email forms? I would like to keep a customer's email address in the database record and press a button that opens a new email message with the customer's email address already in the "To:" field

Thx!

 

[Chris Nebinger]

Yes, check out:
DoCmd.SendObject


The help file should show some good examples.


Chris Nebinger

-----Original Message-----
Is there a way to insert a database field into email

forms? I would like to keep a customer's email address in
the database record and press a button that opens a new
email message with the customer's email address already in
the "To:" field.

 

[Cheryl Fischer]

An additional technique, is to use the following behind your command button
(presumes that the control on your form containing the email address is
named Email:

Dim strEmail As String

strEmail = "mailto:" & Me!Email
Application.FollowHyperlink address:=strEmail

Make sure that the field containing the email address is a Text field, as
opposed to a Hyperlink field.
--

Cheryl Fischer, MVP Microsoft Access

Is there a way to insert a database field into email forms? I would like

to keep a customer's email address in the database record and press a button
that opens a new email message with the customer's email address already in
the "To:" field.

 

[Chris Rainone]

Ok, how do I hand multiple email address' from Access to Outlook express so
that an email with multiple recepients will be created with the same report
being sent out by using the docmd.mailto function

I've looked all over on these boards and need some further assistance.

Thanks,
Chris Rainone

Is there a way to insert a database field into email forms? I would like

to keep a customer's email address in the database record and press a button
that opens a new email message with the customer's email address already in
the "To:" field.

 

[Arkansas Lady]

Chris,

I keep all my emails in a table so that I can add, edit or select only certain people. Then I'll right a function where I loop through the table. Be sure to separate with "; ". If they are the same people each time, you can put them in the "TO" criteria of the send object. Just be sure to separate them with "; ".