Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2021, 05:42 AM
khalilansari khalilansari is offline Mail Merge Data with Multiple Excel Sheets Windows 10 Mail Merge Data with Multiple Excel Sheets Office 2019
Novice
Mail Merge Data with Multiple Excel Sheets
 
Join Date: Nov 2021
Posts: 1
khalilansari is on a distinguished road
Exclamation Mail Merge Data with Multiple Excel Sheets


Hello seniors!
I want to use mail merge data in word from Multiple Excel Sheets But there is no option to choose 2nd or 3rd sheet data. Can Anyone help me about this issue to resolve it that my data which have 8 sheets and I want to convert it with my requirements formate through mail merge fields.
Reply With Quote
  #2  
Old 11-25-2021, 01:41 PM
macropod's Avatar
macropod macropod is offline Mail Merge Data with Multiple Excel Sheets Windows 10 Mail Merge Data with Multiple Excel Sheets Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Mailmerges only work with a single data source - in this case a single worksheet. Depending on your workbook structure and output requirements, however, a combination of meregefields and DATABASE fields may suffice. See, for example:
https://www.msofficeforums.com/mail-...-multiple.html
https://www.msofficeforums.com/mail-...tml#post151706
Merge excel list into Word Receipt
(the second of these uses a macro to apply some additional formatting).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge, multiple excel sheets

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Data with Multiple Excel Sheets Mail Merge: Using One Excel File with Multiple Sheets Townshend Mail Merge 19 06-25-2021 12:39 AM
Mail Merge Data with Multiple Excel Sheets 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 Data with Multiple Excel Sheets Mail Merge Student Transcript - Multiple Years from multiple sheets aizah2018 Mail Merge 1 11-11-2018 01:27 AM
Mail Merge Data with Multiple Excel Sheets Excel 2013 Pulling data from 1 table to multiple sheets Justcallmeeesa Excel 2 04-14-2016 09:15 AM
Mail Merge Data with Multiple Excel Sheets How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 PM.


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