Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge can't find data source in Office XP...but it could in 2000!
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Come? | Mailmerge | |||
Mail Merge Error - can't find data source | Mailmerge | |||
printing a data source from a mail merge document | Mailmerge | |||
mail merge default data source location | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |