Merging Lists

Souriane · #1 07-07-2022, 09:13 AM

Hi!

I am really advanced in Word but today, I just can't figure out! All a need is a tutorial online or at least, the words I should search on Google to find examples.

I want to do a merging with a DB Access that is very badly created but I have to do with it!

Here what the DB fields might look like (I will simplify):

NameOfThePerson
Committee1 (yes/no field)
Committee2 (yes/no field)
Committee3 (yes/no field)
Committee4 (yes/no field)
etc.

There is 25 committee (!) Again, I know it is not how to create a DB but this is what was given to me and I do not have time to recreate it.

In Word, in a single file, I would like to be able to merge and get something like this:

Committee 1
Joe
Peter
Eric

Committee 2
Joe
John
Claire

Committee 3
Joe
Claire
Emily

I know there is a way to do that kind of merging but I can't remember how and have no idea what to search the internet for!

Any help would be very much appreciated!

Souriane

Guessed · #2 07-07-2022, 04:02 PM

Have a look at the #1 sticky post (Microsoft Word Catalogue/Directory Mailmerge Tutorial) in the Word Mail Merge thread. This looks a lot like your requirement.
https://www.msofficeforums.com/mail-...-tutorial.html

Souriane · #3 07-08-2022, 07:00 AM

Thank you Andrew for taking the time to answer.

If the database was build by a pro, Macropod's post would be the answer but unfortunately it is build by a beginner. So I am unable to use the "Category" technique because my "categories" are 25 different fields!

Oh! well! I guess I will have to rebuild this database one day soon! :'(

But I am still open to other solutions!!!

Thanks!

Souriane

Guessed · #4 07-10-2022, 09:17 PM

Try adding a Query in Access to restructure the data. In SQL view this might look like this

Code:

SELECT Person, "Comm 1" AS Committee
FROM Table1
WHERE (((Committee1)=True));

UNION ALL
SELECT Person, "Comm 2" AS Committee
FROM Table1
WHERE (((Committee2)=True));

UNION ALL
SELECT Person, "Comm 3" AS Committee
FROM Table1
WHERE (((Committee3)=True));

You should be able to use that query as your merge source (or use it as the basis for an Access Report)

Souriane · #5 07-11-2022, 06:39 AM

Guessed!!! you are a Master!!!!

When I saw you second answer I wanted to bang my head on the wall! I have never done SQL before, always avoided it because it is to hard for my little head! But Monday Morning, 8:30, why not try it. Guessed made the effort to answer me, I'll make the effort to understand...!

It took me an hour to figure out. Trial and Error over and over. Until... yeahhhh!!! I tried with only 3 committees at first and I finally got the result I wanted!!!! I will do it with the 25+ committees later. But I am over the moon!

And, oh!! Now that I understand how SQL works, I might begin to learn and work with it in the future as it look easier to do it this way than in the QBE mode! And you can do things way more complex!!

Thank you soooooo much! You made much more than my day!!!!

Souriane

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing two lists and extracting values missing from both lists	Dave T	Excel Programming	4	11-01-2018 11:51 PM
Creating global contact lists (distribution lists) Outlook 2011 Mac	pengyou	Outlook	0	09-10-2016 02:18 PM
I want to create a lists within lists (nested merges)	AndyS	Mail Merge	10	12-11-2015 03:05 PM
Merging bibliographies with word documents using separate master lists	Cimballi	Word	3	07-01-2014 03:45 AM
Merging Distribution Lists	twiga	Outlook	0	12-27-2009 08:23 PM