[pablo]

Hi
In word when i open a data source for a mail merge, I have to click through
3 4 layers to get to the excel file I need, how can i set up the Select Data
Source window to look in the last place I selected a file from?

Thanks
-Paul

[Suzanne S. Barnhill]

You can't do that, unfortunately, but if your data sources are all in Excel,
you can at least make it look in an Excel folder first. This requires a
Registry edit.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"pablo" wrote in message
...
Hi
In word when i open a data source for a mail merge, I have to click
through
3 4 layers to get to the excel file I need, how can i set up the Select
Data
Source window to look in the last place I selected a file from?

Thanks
-Paul

[Cindy M -WordMVP-]

Hi Suzanne,

You can't do that, unfortunately, but if your data sources are all in Excel,
you can at least make it look in an Excel folder first. This requires a
Registry edit.

I've been under the impression, since Office XP, that one can't change the
target folder, not even in the Registry. Do you have link to this information?

Cindy Meister

[Cindy M -WordMVP-]

Hi ?B?cGFibG8=?=,

In word when i open a data source for a mail merge, I have to click through
3 4 layers to get to the excel file I need, how can i set up the Select Data
Source window to look in the last place I selected a file from?

Unfortunately, you don't mention the version of Word you're using? What folder
are you currently defaulting to? Have you considered creating a Windows
Shortcut in this folder to the other locations where you have data sources?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[Suzanne S. Barnhill]

No, someone (Graham?) posted this information in one of the NGs
recently...ah, found it, in a thread called "Data Source folder" on June 15:

"It can be set to any sub folder directly below 'My Documents', but no
other location, by means of a registry edit.

"My
Computer\HKEY_CURRENT_USER\Software\Microsoft\Offi ce\11.0\Common\DataService
s

"However if you attempt to change this to another folder location it will be
ignored and the My Documents parent folder will be used instead."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Cindy M -WordMVP-" wrote in message
news:VA.0000c1c2.01b4a4d2@speedy...
Hi Suzanne,

You can't do that, unfortunately, but if your data sources are all in
Excel,
you can at least make it look in an Excel folder first. This requires a
Registry edit.

I've been under the impression, since Office XP, that one can't change the
target folder, not even in the Registry. Do you have link to this
information?

Cindy Meister

[Cindy M -WordMVP-]

someone (Graham?) posted this information in one of the NGs
recently...ah, found it, in a thread called "Data Source folder" on June 15:

thanks for this, Suzanne :-)

Cindy Meister