Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2022, 08:04 PM
JennyAM JennyAM is offline Mail Merge with 4 datasets Windows 11 Mail Merge with 4 datasets Office 2021
Novice
Mail Merge with 4 datasets
 
Join Date: Aug 2022
Posts: 1
JennyAM is on a distinguished road
Default Mail Merge with 4 datasets

I hope someone can assist with a work document I have been intermittently working on and off for months.
The document is a reminder document to be sent out to medical centres for children who are overdue for vaccinations.

. There is the individual's information (e.g. surname, given name, DOB etc)
. The name of the medical centre (which is in the same table in the Word document as the individual's information)
. The vaccinations the individual is overdue for


. The vaccinations the individual has had previously

The data can either be in one spreadsheet or 4 sheets

Unfortunately I don't have the skillset to figure this out. I have tried to modify other information I have found on this forum with no success.

I have requested support from the IT department and no luck..

Thanks
Jen
Reply With Quote
  #2  
Old 08-24-2022, 04:42 PM
macropod's Avatar
macropod macropod is offline Mail Merge with 4 datasets Windows 10 Mail Merge with 4 datasets Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,719
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See the discussion in the Microsoft Word Catalogue/Directory Mailmerge Tutorial 'Sticky' thread at the top of this page (https://www.msofficeforums.com/mail-...-tutorial.html) on the use of DATABASE fields in conjunction with a mailmerge. The article includes links to oher threads with examples. Depending on what you're trying to achieve, you may be able to the approach described there. It is possible to use more than one DATABASE field in a mailmerge maind document, each refencing a different data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with 4 datasets Is there a way to do a mail merge type of addition of data after a mail merge has been done? mtandino Word 4 06-01-2021 02:00 PM
Mail Merge with 4 datasets Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file sureshbvs Word VBA 1 03-12-2021 05:42 AM
Mail Merge with 4 datasets Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
Merge two datasets on the basis of unique identifiers ballpoint Excel 0 10-16-2019 04:35 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 AM.


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