TechSpot - PC Technology News and Analysis

pianoko · #1 07-13-2007

I have a list of nearly 400 mailing lists along with their owner. I have created a mail merge document to send an email to the list owners about upgrading to a new system. The file was generated by list name, not by owner name. So I have owners with 15 lines because they have 15 different lists. When I do the mail merge, that owner will receive 15 emails, instead of 1 with the 15 lists listed. What I want is to consolidate the file and organize it by owner name so that there is the same number of rows as there are owners, and all the owners lists appear in the same cell under the "lists" column.

I will demonstrate....

What I have now.....

Code:

User1     user1email     list1
User1     user1email     list2
User1     user1email     list3

.........

What I want is...

Code:

User1     user1email     list1
                         list2
                         list3

I thought access may have a tool that could do this easily, but I have zero knowledge in access. Do you have any suggestions?

Similar Topics
Thread	Thread Starter	Forum	Replies	Last Post
Excel Crashing when Opening Access/Outlook	YeoMan223	Windows OS	3	06-29-2007 05:17 PM
Program for managing music, deleting duplicate entries, sorting?	korrupt	Misc. Software & Utilities	4	09-28-2006 05:41 AM
Excel files update from Access	Michelle2	Misc. Software & Utilities	0	11-09-2005 06:52 AM
Deleting duplicate (?) files	hewybo	Storage & Networking	2	11-07-2005 01:37 PM
Excel 2000 Importing data from Access DB	Michelle2	Misc. Software & Utilities	0	06-21-2005 04:28 AM