View Single Post
 
Old 08-22-2014, 12:39 PM
paulys paulys is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default if address is repeated in subsequent records

Dear all, I am very new to mail merge and hence am reluctant to present my problem, I have a data source having fields namely "name", "add1", "add2", "no of items" and "quantity of items". In the main document(Word), after finishing mail merge, the contents of "no of items" and "quantity of items" is displayed in a tabular format, having one row having two columns.

In the data source, the "name" may repeated in the subsequent records, meaning the corresponding "no of items" and "quantity of items" relates to the same person.

In such cases I wish to have "no of items" and " quantity of items" of the same name in a single page when mail-merged. That is if the same "name" is appearing in the data base in three rows (records), there should be only one merged record with all the 3 data (contained in "no of items" and "quantity of items") in three rows in tabular form with 3 rows having two columns.

I hope i have presented the problem... Thanks in advance
Reply With Quote