Hi,

I'm trying to find a solution to a problem a colleague of mine is
having. He has a database which uses VB to generate an Excel
spreadsheet and save it onto a network drive, then to mail merge this
into an existing Word Document stored elsewhere on the same network.
The db is accessed by users via Citrix (Terminal Services), and until
recently when this was all done via Office 2000 it all worked fine.

However, since a recent upgrade to Office XP SP2 on the Citrix server
(just to clarify NOT SP3, as we are aware of quite specific issues with
this version concerning mail merges!), a problem has occurred. Upon the
Word doc opening, the mail merge toolbar functions are greyed out as
though Word cannot find the data source. However, if the user manually
selects the data source, the Document and mail merge then work fine.
However, the next time a Citrix session is launched, the data source
again is not automatically found.

We have tried an experiment, and if the Word Doc is modified to point
to an Excel data source in the same drive and folder as itself, then
the whole thing is opened via Citrix, this time it works fine.

The network drive that the Excel spreadsheet is usually saved to is
basically the personal folder for the current Citrix user...my initial
thought is that this must surely be some sort of permissions issue with
that particular drive seeing as the mail merge does work for local
versions of the same spreadsheet, but the thing that's puzzling me is
that it's the upgrde from Office 2000 to XP that seems to have caused
the problem, and permissions haven't changed....could anyone more
familiar with Office XP Mail Merges suggest anything I may have
overlooked here?

Thanks, Mark