Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2020, 12:40 PM
karan1686 karan1686 is offline Mail Merge with Excel Data Windows 10 Mail Merge with Excel Data Office 2016
Novice
Mail Merge with Excel Data
 
Join Date: Mar 2020
Posts: 1
karan1686 is on a distinguished road
Default Mail Merge with Excel Data

Hi




I have a list with 5-10,000 customers which I want to split between 200 staff.
I want to allocate equal amount to each staff and email them the list of customers they are responsible for.



Can this be done via mail merge? I canít figure it out.


I have the excel spreadsheet with customer names, tel number, address etc and a separate excel sheet with staff emails Thanks
Reply With Quote
  #2  
Old 03-26-2020, 04:43 PM
macropod's Avatar
macropod macropod is online now Mail Merge with Excel Data Windows 7 64bit Mail Merge with Excel Data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,074
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Is there anything in the workbook that identifies which staff member is responsible for which customer? If so, one option would be to use a DATABASE field in a normal email mailmerge main document and a macro to drive the process. An outline of this approach can be found at: Many to one email merge using tables - Microsoft Community Or, if your Excel workbook has a separate worksheet that with just a single instance of each of staff member's name, a DATABASE field in a normal ‘email’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at: Mail Merge - To a Word Table on a Single Page - Microsoft Community
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I mail merge data on front side (page 1) and static data (page 2) back of business cards? dhouston1000 Publisher 0 01-24-2020 04:34 PM
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 with Excel Data Mail Merge using variable data in Excel dewestone Mail Merge 1 12-20-2016 01:09 PM
Is data merge and mail merge the same thing? ikearns Mail Merge 1 09-12-2014 03:53 AM


All times are GMT -7. The time now is 11:15 PM.


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