Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2013, 01:55 AM
alleycat1998 alleycat1998 is offline Enable Mail Merge Data Source always in same folder Windows 7 64bit Enable Mail Merge Data Source always in same folder Office 2007
Novice
Enable Mail Merge Data Source always in same folder
 
Join Date: Apr 2013
Posts: 1
alleycat1998 is on a distinguished road
Default Enable Mail Merge Data Source always in same folder

Dear all,



I have a word document with mail merge enabled and the data source is a Excel (xls) file.

As the file always pass around among the colleague. It's quite troublesome everytime they need to link again the data source.

May i know the way to enable MS Word to look for the data source file within the same folder as the word file.

Thank you
Reply With Quote
  #2  
Old 04-10-2013, 03:02 AM
macropod's Avatar
macropod macropod is offline Enable Mail Merge Data Source always in same folder Windows 7 64bit Enable Mail Merge Data Source always in same folder 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

Perhaps you should re-evaluate why you keep moving the datasource. If you store in in a folder accessible to all users, it then doesn't matter whether you copy or move the mailmerge main document to another folder from which the datasource can be accessed.

The only reliable way around this would be to save the mailmerge main document as an ordinary document, then use a macro to drive the mailmerge process. That, in turn, requires embedding the mailmerge SQL query into the macro code. And, of course, you then have the usual macro security issues to address.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM
define a mail merge data source using unc (universal naming convention) charlesandrews Mail Merge 0 08-21-2012 10:33 AM
Mail Merge using Word 2010 - Header source not be recognized Gage262 Word 8 02-01-2012 11:08 AM
Enable Mail Merge Data Source always in same folder How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:10 PM.


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