Jump to content

Mail merge of portal fields


malagasy
 Share

This topic is 5757 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm using a portal to add records in an order. In this specific cases, the added records are date when our service will be provided and the name of employee in charge of providing it.

I'd like this info to appear in the letter to be sent to the customer using mail merge or something like this.

What should I do ?

Im my database, I have several tables witht he following relationships:

Customers <--> Orders <--> Ordersline <--> Products

Thanks for your help

Link to comment
Share on other sites

I would steer you toward the new FileMaker 8.5 List function since it will allow you to take all of the data from a portal and display it in a calculation result with returns between each portal row. You can further manipulate the return-separated list with the Substitute function and other text functions to get your desired result. Then, just use the calculation field as the body of your email in the Send Mail script step.

Link to comment
Share on other sites

This topic is 5757 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.