Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-06-2018, 05:50 PM
Boatman Boatman is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jul 2018
Location: Manassas, Virginia
Posts: 2
Boatman is on a distinguished road
Default which excel database is my word merge document accessing

A particular Word 2010 merge document accesses an Excel database.


Where in that Word document does it say which database?
Reply With Quote
  #2  
Old 07-06-2018, 11:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
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

For a mailmerge main document that has successfully connected to its data source (i.e. after answering ‘Yes’ to the mailmerge SQL prompt), go to Mailings>Edit Recipient List and hover over the file named in the 'Data Source' box. You should now see the full name & path of the data source.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-07-2018, 10:43 AM
Boatman Boatman is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jul 2018
Location: Manassas, Virginia
Posts: 2
Boatman is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
For a mailmerge main document that has successfully connected to its data source (i.e. after answering ‘Yes’ to the mailmerge SQL prompt), go to Mailings>Edit Recipient List and hover over the file named in the 'Data Source' box. You should now see the full name & path of the data source.
Thank you -- that does it
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing a database from Excel melvwahl Excel Programming 1 07-18-2017 01:31 PM
Merge fields from Excel into word document Tonykiwi Word 5 10-11-2015 12:54 PM
Creating a table in one document of WORD from EXCEL with Mail Merge Joseph.Comerford@bentley. Mail Merge 1 04-18-2015 01:19 AM
Is it possible to use an Access Database to merge specified PDF documents into word? bgranzow Mail Merge 3 01-07-2014 09:41 PM
Exporting many Word files to a database or Excel Mdalu Word 0 05-23-2011 02:55 AM


All times are GMT -7. The time now is 01:42 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft