1 Reply Latest reply on Mar 21, 2010 9:53 AM by MarkHolbrook

    Send email - Field values

    MarkHolbrook

      Title

      Send email - Field values

      Post

      Hi all...

       

      Using FMProV11 mac.  My database is a simple contact database.

       

      I'm new so perhaps this question is easy... I've searched but have not found the answer...  I'm using the send email menu option to send out emails to various records in the database.   One of the things I need to do is to get people to verify information so I wanted to sent out an email to a record set which was something like:

       

      Hello Member,

       

      Please update your information below for the database:

       

      Member name

      Position

      Telephone

      email

       

      But obviously I want those "fields" to be replaced with the values from each record in the record set.  So an email to myself might look like:

       

      Hello Member,

       

      Please update your information below for the database:

       

      Mark

      President

      555-1212

      email@email.com

       

      I have had success getting an email per record. That was easy.  But in the email section of the dialog I have not figured out how to have both text I type in (in quotes) and fields replaced from the current record.  I tried using the arrow to select a field but it wants to replace the entire text with that field.

       

      How do I have both typed in text and fields that are replaced with values from the current record at the same time?

       

      Thanks in advance!