Inserting database fields into email forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
Click to expand...
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.
 
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



BT said:
Is there a way to insert a database field into email forms? I would like
Click to expand...
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.
 
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

BT said:
Is there a way to insert a database field into email forms? I would like
Click to expand...
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,

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 "; ".
 
Back
Top