Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-22-2014, 12:39 PM
paulys paulys is offline if address is repeated in subsequent records Windows 7 32bit if address is repeated in subsequent records Office 2007
Novice
if address is repeated in subsequent records
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
if address is repeated in subsequent records Find max number of same subsequent character NobodysPerfect Word VBA 9 05-25-2014 01:10 AM
if address is repeated in subsequent records Deleting a numbered section and updating subsequent numbers Gnobles Word 4 12-19-2013 07:25 AM
if address is repeated in subsequent records Open documents changing font on subsequent templates mikmak Word 7 03-04-2012 08:23 PM
Concatenated data in subsequent rows doorsgirl Excel 4 09-15-2011 10:37 PM
if address is repeated in subsequent records Repeated Cells in different sheets mhdagtas Excel 2 04-27-2011 12:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft