Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Mail Merge: Using One Excel File with Multiple Sheets Mail Merge: Using One Excel File with Multiple Sheets
Register FAQ Mark Forums Read

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 06-07-2019, 01:43 AM
Sarki76 Sarki76 is offline Mail Merge: Using One Excel File with Multiple Sheets Windows 10 Mail Merge: Using One Excel File with Multiple Sheets Office 2019
Novice
  
Join Date: Jun 2019
Posts: 7
Sarki76 is on a distinguished road
Default
OK, I got that working by separating the exfel file containing multiple sheets into several individual files.
BUT: how am I supposed to get the external data refreshed automatically when I change the record in the main doc?
is there a way to get it auto-updated?
Thx in advance!
  #2  
Old 06-07-2019, 04:35 AM
macropod's Avatar
macropod macropod is offline Mail Merge: Using One Excel File with Multiple Sheets Windows 7 64bit Mail Merge: Using One Excel File with Multiple Sheets Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
Quote:
Originally Posted by Sarki76 View Post
OK, I got that working by separating the exfel file containing multiple sheets into several individual files.
Why did you do that? It's quite unnecessary.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
  #3  
Old 06-22-2021, 03:31 PM
QNRyfzKPYQyC QNRyfzKPYQyC is offline Mail Merge: Using One Excel File with Multiple Sheets Mac OS X Mail Merge: Using One Excel File with Multiple Sheets Office 2016 for Mac
Novice
  
Join Date: Jun 2021
Posts: 4
QNRyfzKPYQyC is on a distinguished road
Default did Office change? I get connection errors
Hi, have been trying to make this work on my mac but unfortunately without success. I've managed to connect to the file, but the sql-string seems te generate an error ("can't open data file" translated from dutch). I've simpified the sql from the tutorial above into

\s " SELECT [Subordinate Forename] FROM [Sheet1$] WHERE [Manager ID] = { MERGEFIELD Manager_ID } "

Still no luck. Please help.
test.docx

test.xlsx
Closed Thread

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge: Using One Excel File with Multiple Sheets Merge one Excel file into multiple Word Documents Rushpac Mail Merge 2 01-27-2017 02:49 PM
Mail Merge: Using One Excel File with Multiple Sheets Insert slip sheets during a mail merge mcboats2 Mail Merge 1 12-07-2015 05:01 PM
Mail Merge: Using One Excel File with Multiple Sheets Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
Mail Merge: Using One Excel File with Multiple Sheets Code for mail merge to reference saved excel file jtemp57 Word VBA 10 12-16-2013 11:02 PM
Mail Merge: Using One Excel File with Multiple Sheets How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 AM.

Contact Us - Privacy Statement - Top

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