Hi,
We are trying to use the mailmerging function in WPTools 5. It works very well for standard merge fields, but we dont know how to solve the following case.
We want to manually perform a mailmerge with repeating lines in a longer text. For example this could be used for an invoice, where the customers information is filled in via ordinary mailmerge, and the invoice lines (ordered items) are filled in via manual mailmerge.
Simply described: We want to repeat parts of the text an arbitrary number of times and then manually fill the mailmerge fields of the repeated text.
Example with a simple invoce form:
*************************
<CustomerName>
<CustomerAddress>
<CustomerZip> <CustomerCity>
Ordered items
<Code> <Title> <Amount>
*************************
We are able to locate (find the field and locate the cursor) at the mailmerge field <Code>. But we have not been able to repeat the line with this mailmerge field on an arbitrary number of times. More specific: We want to copy the line "<Code> <Title> <Count>." to a variable. Then we want to insert the contents of this variable into our rtf the same number of times as the customer has items in the invoice.
The result should look something like this:
*************************
Ola Normann
West End 245
7000 Trondheim
Ordered items
1234 Title of product 123 $
2345 Title of product 234 $
3456 Title of product 345 $
*************************
Our questions:
1. Is it possible to manually perform this kind of mailmerging in wpTools?
2. Is there any better solutions? Maybe Wp Reporter? It is important that it is flexible.