Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2020, 11:01 PM
Cherish Cherish is offline Mail merge from 2 different data source Windows 8 Mail merge from 2 different data source Office 2013
Novice
Mail merge from 2 different data source
 
Join Date: Mar 2020
Posts: 1
Cherish is on a distinguished road
Default Mail merge from 2 different data source

Team,

Need assistance with regards to mail merge in word



Situation
Need to send monthly usage bill( day wise split with diffrent services used) to multiple clients.

I am able to use merge option for the contents (eg. name, address etc..) however for each person day wise details is different.

Those details I have in different Excel sheets

Is there an option i can merge these two data source into one
Reply With Quote
  #2  
Old 04-01-2020, 01:28 AM
macropod's Avatar
macropod macropod is offline Mail merge from 2 different data source Windows 7 64bit Mail merge from 2 different data source Office 2010 32bit
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

Mailmerge can only use a single data source. That said, you could use a mailmerge in conjunction with a DATABASE field to consolidate data from different worksheets. See: https://www.msofficeforums.com/mail-...populated.html
__________________
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 from 2 different data source Mail Merge - Cannot Locate Source Data Karen615 Mail Merge 2 08-03-2018 05:40 PM
Mail Merge using HTML Data Source chadnewman Mail Merge 0 09-21-2017 07:14 AM
Mail merge from 2 different data source Migrating Mail Merge Data Source jameswang Mail Merge 2 06-07-2015 03:03 AM
Mail merge from 2 different data source Enable Mail Merge Data Source always in same folder alleycat1998 Mail Merge 1 04-10-2013 03:02 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 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