[Robo]

In Word 2000 I have a simple macro to do a mailmerge, however the header and
data source will be in differenct locations for different users. Is there a
way to include the browse function in a macro?
--
Robo

[Peter Jamieson]

I think you would have to use the approach described at

http://word.mvps.org/FAQs/MacrosVBA/WordDlgHelp.htm

with the dialog boxes named

wdDialogMailMergeOpenHeaderSource

and

wdDialogMailMergeOpenDataSource

However, if you want to extract the name that the user selected in the
dialog, rather than simply executing the dialog, be careful because the name
returned my just contain the file name and not the full pathname of the
file.

Peter Jamieson

"Robo" wrote in message
...
In Word 2000 I have a simple macro to do a mailmerge, however the header
and
data source will be in differenct locations for different users. Is there
a
way to include the browse function in a macro?
--
Robo

[Robo]

Thanks Peter, that's exactly what I needed.
--
Robo


"Peter Jamieson" wrote:

I think you would have to use the approach described at

http://word.mvps.org/FAQs/MacrosVBA/WordDlgHelp.htm

with the dialog boxes named

wdDialogMailMergeOpenHeaderSource

and

wdDialogMailMergeOpenDataSource

However, if you want to extract the name that the user selected in the
dialog, rather than simply executing the dialog, be careful because the name
returned my just contain the file name and not the full pathname of the
file.

Peter Jamieson

"Robo" wrote in message
...
In Word 2000 I have a simple macro to do a mailmerge, however the header
and
data source will be in differenct locations for different users. Is there
a
way to include the browse function in a macro?
--
Robo