Microsoft Office Forums Adding new data to data source for Letter

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2019, 04:19 PM
emk_24 emk_24 is offline Adding new data to data source for Letter Mac OS X Adding new data to data source for Letter Office 2016 for Mac
Novice
Adding new data to data source for Letter
 
Join Date: Nov 2019
Posts: 3
emk_24 is on a distinguished road
Default Adding new data to data source for Letter

I have a complex Letter template . I want to add some new customer data to my Excel data source, but the template does not include the new data, even if I save it again. It's not practical to re-create the letter template each time new customer data sets arrive.



Am I doing something wrong or is that functionality not available?

If it is not available, are there any work-arounds?

Any help would be appreciated.
Reply With Quote
  #2  
Old 11-27-2019, 05:00 AM
macropod's Avatar
macropod macropod is offline Adding new data to data source for Letter Windows 7 64bit Adding new data to data source for Letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,649
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Any new data you add to the data source will be available to the mailmerge main document and any new mailmerges output documents produced from it, but not to any mailmerge output documents you have already produced. Of course, if someone has defined the data source as applying to only a named range, for example, then only that range will be accessed.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-27-2019, 09:33 AM
emk_24 emk_24 is offline Adding new data to data source for Letter Mac OS X Adding new data to data source for Letter Office 2016 for Mac
Novice
Adding new data to data source for Letter
 
Join Date: Nov 2019
Posts: 3
emk_24 is on a distinguished road
Default

Thank you so much for your reply. It sounds like I should be able to add a new customer to my data source and create a new mail merge output document. That's promising. It sounds like I made a mistake somehow in adding the new customer data to the data source then. I did not apply a named range, and I tried putting the new data in a few different places (as the last row and as a new row in the middle of the data source) but that didn't seem to work. Any troubleshooting suggestions?
Reply With Quote
  #4  
Old 11-27-2019, 03:29 PM
macropod's Avatar
macropod macropod is offline Adding new data to data source for Letter Windows 7 64bit Adding new data to data source for Letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,649
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

If it's an Excel data source, simply adding the new data to a new row should be sufficient for the mailmerge to 'see' it - once the workbook has been saved and you open the mailmerge main document after saving the workbook.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 11-27-2019, 05:29 PM
emk_24 emk_24 is offline Adding new data to data source for Letter Mac OS X Adding new data to data source for Letter Office 2016 for Mac
Novice
Adding new data to data source for Letter
 
Join Date: Nov 2019
Posts: 3
emk_24 is on a distinguished road
Default

Thank you! I tried this and it worked. I think my mistake yesterday might have been that I left the mail merge main document open while I saved the new data. Regardless, it worked today when I followed your instructions. Thanks!
Reply With Quote
Reply

Tags
data source

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding X Y coordinates from 3D Map to source data NOLA Excel 0 04-11-2017 11:10 AM
Adding new data to data source for Letter Adding a Placeholder to an existing Data Source nfotx Mail Merge 2 08-04-2015 08:25 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
Powerpoint: adding data to trend lines w/o data labels HaiLe PowerPoint 0 04-11-2011 09:21 AM


All times are GMT -7. The time now is 03:59 PM.


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