Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2016, 11:57 AM
sjbax09 sjbax09 is offline How can I use mail merge to send managers a list of employees? Windows 10 How can I use mail merge to send managers a list of employees? Office 2013
Novice
How can I use mail merge to send managers a list of employees?
 
Join Date: Jan 2016
Posts: 2
sjbax09 is on a distinguished road
Default How can I use mail merge to send managers a list of employees?

Hello

I don't know if it's possible since I've never really used mail merge before but:



I have a spread sheet with name of people that need to go on training session with the name of the persons manager as well.
I want to use mail merge to send emails to each of the manages with a table of the people that need to do training and what course they need to go on. Each manager has a different amount of employees so I cant just have a fixed amount of rows in the table.

Does anyone have any idea what i'm on about or how to do it?
Reply With Quote
  #2  
Old 01-10-2016, 02:48 PM
macropod's Avatar
macropod macropod is offline How can I use mail merge to send managers a list of employees? Windows 7 64bit How can I use mail merge to send managers a list of employees? 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

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. For your purposes, see the topic titled 'Merging by Catalog/Directory to E-Mail'. Please read the tutorial's introduction!

Another approach would be to be to use a DATABASE field inconjunction with a normal letter merge and a macro to drive the process. For a recent solution along these lines, see: http://answers.microsoft.com/en-us/o...1-1996c14dca5d

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-10-2016, 03:41 PM
sjbax09 sjbax09 is offline How can I use mail merge to send managers a list of employees? Windows 10 How can I use mail merge to send managers a list of employees? Office 2013
Novice
How can I use mail merge to send managers a list of employees?
 
Join Date: Jan 2016
Posts: 2
sjbax09 is on a distinguished road
Default

Thank you. I saw this on a thread earlier but if anything i'm slightly more confused now than when I started hahaha
Reply With Quote
  #4  
Old 01-10-2016, 10:12 PM
gmayor's Avatar
gmayor gmayor is offline How can I use mail merge to send managers a list of employees? Windows 10 How can I use mail merge to send managers a list of employees? 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

If you use http://www.gmayor.com/ManyToOne.htm (read the web page). Then what you ask is straightforward.

Sort the worksheet on the manager name field. Put the manager's name field at the top of the page and under it put a one row table (with or without a border. Put the fields relating to the people in the table cells, and merge many to one with the fields in the table as child fields and the manager field as the key field.

Once familiar with the principles you can format the document as required before running the merge.
__________________
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I use mail merge to send managers a list of employees? Mail Merge - Send Each Category to a New Page cjw Mail Merge 2 10-23-2014 01:25 PM
How can I use mail merge to send managers a list of employees? mail merge in excel to send pdf forms heyullama Excel 7 12-01-2013 03:32 PM
How can I send E-mail to distribution list in different time-zones Niels Outlook 0 09-12-2012 09:59 AM
Send e-mail message in Finish & Merge CDTom Mail Merge 1 08-24-2012 12:52 AM
How can I use mail merge to send managers a list of employees? Send fax with mail merge image (logo) problem dipak.patel@i-link.co.in Mail Merge 1 01-06-2011 10:10 AM

Other Forums: Access Forums

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