Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2020, 04:18 PM
Marcia's Avatar
Marcia Marcia is offline Mail merge with 2 sources Windows 7 32bit Mail merge with 2 sources Office 2013
Expert
Mail merge with 2 sources
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Mail merge with 2 sources

Hi. Our office pay slip contains info every month through a mailmerge from Excel. I would like to add a "To Date" column after the "This Month" column in the pay slip but the source is in another sheet but the same workbook. Is there a way do this?
My laptop cannot connect to with the cp hotspot so I cannot attach a file, sorry.


Thank you.
Reply With Quote
  #2  
Old 07-03-2020, 07:55 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge with 2 sources Windows 10 Mail merge with 2 sources Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Can you add another worksheet to the workbook that contains the information from both sheets? Can you create another workbook that contains the information from both sheets in the other workbook? If neither, what is the relationship between 'This Month' and 'To Date'?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 07-03-2020, 09:31 PM
Marcia's Avatar
Marcia Marcia is offline Mail merge with 2 sources Windows 7 32bit Mail merge with 2 sources Office 2013
Expert
Mail merge with 2 sources
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

The workbook contains the payrolls per month. Jan sheet is January payroll, Feb sheet is February payroll and so on. There is a Consol sheet that consolidates (sums) all the monthly payrolls. From the monthly payroll, we prepare individual pay slip (Word) for each employee using mail merge. The This Month is the basic salary, allowances and deductions for the payroll month, say June. The To Date should be the total salaries, allowances and
Deductions of the employee from January to June. The source of the To Date is the Consol sheet
Reply With Quote
  #4  
Old 07-04-2020, 09:38 PM
Marcia's Avatar
Marcia Marcia is offline Mail merge with 2 sources Windows 7 32bit Mail merge with 2 sources Office 2013
Expert
Mail merge with 2 sources
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

I am attaching sample pay slip and payroll.
Attached Files
File Type: xlsx PAYROLL.xlsx (156.2 KB, 9 views)
File Type: doc PAY SLIP.doc (117.5 KB, 9 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge with 2 sources 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
Mail merge - data sources Sarki76 Mail Merge 2 09-02-2019 01:28 AM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Choosing Mail Merge templates and excel Data Sources using drop downs dushan997 Mail Merge 3 08-04-2017 07:54 PM
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 03:14 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