Insert Field in email

[drichar]

I am trying to make script that when it sends this email, it puts this saluation at the beginning:

Dear ,

AND I can put something like this in the middle:

, we are happy to help you.

Struggling with both of those.

[mr_vodka]

Use the send email script step with the option as calculation for the body.

"Dear " & FName &

¶ &

¶ &

FName & ", we are happy to help you."

If you want to send it to the all the clients in the found set of records, then use the Multiple Email option.

[Ender]

Or you might use your merge letter format for the email body, and have a calc use multiple substitutes to replace the merge text with the actual field values:

substitute( body ; [ ""; FirstName ] ; [ "" ; LastName ])

[akeslady]

Hi,

I have a similar problem. I am trying to e-mail a description but I can not get the field name to appear in the mail, just the fields. I am using send mail - calculation.

Example:

Description::Directions &

¶ &

¶ &

Description::Lenght &

¶ &

Description::Width

When it comes out in the e-mail it only says:

A description of the direction...

102

58

I hope you can help!

Thanks in advance!

Mac OS X Tiger

FM Pro Advanced (Not that I am advanced - I just happen to buy it.)

[Ted S]

How about something like this:

Description::Directions & "¶¶" &

"Length: " & Description::Lenght & "¶" &

"Width: " & Description::Width

[akeslady]

Thanks a million!

I have been trying to solve this "problem" the whole day! And how easy it was.

Is it possible to automatically attach a picture to this e-mail? On each "card" In my database I have a picture and when I am going to e-mail a description that "card" is displaying the picture. All pictures are stored in a separate folder.

I hope you can understand what I am talking about.

Thanks again!

[Ted S]

akeslady,

I'm a Windows guy, period. The last time I touched an Apple product was probably 15 years ago. I'm afraid that I can't advise how attachments work on a Mac because I haven't the foggiest idea.

In Windows, at the bottom of the Send Mail dialog box there is a checkbox for adding an attachment. It is here where you provide the path and name of the file that you want to attach. Maybe it is similar on the Mac. You could potentially use a variable to provide the proper path and filename.

I also believe that you can only attach files to an email, as opposed to embedding a picture for instance in the body of an email message. For that you would need to use an SMTP plugin I think.