Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2022, 09:13 AM
Souriane Souriane is offline Merging Lists Windows 10 Merging Lists Office 2019
Advanced Beginner
Merging Lists
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Default Merging Lists

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
Reply With Quote
  #2  
Old 07-07-2022, 04:02 PM
Guessed's Avatar
Guessed Guessed is offline Merging Lists Windows 10 Merging Lists Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 07-08-2022, 07:00 AM
Souriane Souriane is offline Merging Lists Windows 10 Merging Lists Office 2019
Advanced Beginner
Merging Lists
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 07-10-2022, 09:17 PM
Guessed's Avatar
Guessed Guessed is offline Merging Lists Windows 10 Merging Lists Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 07-11-2022, 06:39 AM
Souriane Souriane is offline Merging Lists Windows 10 Merging Lists Office 2019
Advanced Beginner
Merging Lists
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Merging Lists I want to create a lists within lists (nested merges) AndyS Mail Merge 10 12-11-2015 03:05 PM
Merging Lists 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 AM.


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