I have an antiques inventory and I added an send email to the customer and in the message I want this to add some fields of my inventory like ( shipper, tracking number, shipping date) but when I want to add the field to the message it only allow me to add one.

Can somebody help me ?

Create a calculation field, result text, for the body of your email. You can concatenate as many fields and text snippets as you want.

Can you please tell me how ?

Hello,

Based on your

.... when I want to add the field to the message it only allow me to add one.

Based on Bcooney's idea, I came out with a sample. You can see the sample attached. You can modified the information according to your needs.

Hope it helps...

test.zip

My question was to make a send mail with the information taking the fields ? any idea how to do it ?

Hello,

Can you give more information?

If you want to send email with the "Message" containing information, you can go to "ScriptMaker" and find "Send Mail" script.

In "Send Mail" script, click "Specify" and on the Message field, clicked the small black arrow button and choose either "Specify Calculation" or "Specify Field Names."

Moreover, here is another topic information on sending email using VB Script (for more information about email):

http://fmforums.com/forum/showtopic.php?tid/188017/

Hope it helps...

ok I will try to give you an example of what I need.

the subject message will be: Shipping information !

the message has to be:

Hi (new virginiaantiques::Name)

We sent your item by: (new virginiaantiques::Shipper)

Tracking Number: (new virginiaantiques::Traking)

Thanks

Sergio

this is what i need.

new virginiaantiques is my database.

Edited January 23, 200818 yr by Guest

Click on Specify Calculation... and type this into the formula box:

"Hi " & new virginiaantiques::Name 

& "¶¶" &

"We sent your item by: " & new virginiaantiques::Shipper 

& "¶¶" &

"Tracking Number: " & new virginiaantiques::Traking 

& "¶¶" &

"Thanks¶Sergio"

thanks a lot