Topic Options
#40139 - 07/19/12 05:02 PM mail merging a database into PSM
Rose Offline
OL Newbie

Registered: 07/19/12
Posts: 1
any one have any luck trying to merge a database from paypal with ordering multi products and trying to get these products to print out on one packing slip? so we have a common transaction id say on 3 items which are on there own row in excel how can we get these 3 items on one packing slip? anyone with suggestions would be appreciated.

#40144 - 07/20/12 09:49 AM Re: mail merging a database into PSM [Re: Rose]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal

Unfortunately, PrintShop Mail can only load one row of a database per records, it cannot load multiple rows per records. The only workaround would be to have a field for every items you order. However, since you cannot dynamically add fields to a database, you'd have to set a number of fields as the maximum number of items you ever expect to have.

In the end, however, PrintShop Mail isn't really designed to create transactional documents, it is more oriented toward promotional documents. It lacks features that would need to make transactional documents, such as overflowing to a new page when you have more items than fits on one page.

Raphaƫl Lalonde Lefebvre