Local version of Excel file used for mail merge in Word 07 on Vista ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ciegalo - 22 Oct 2007 14:54 GMT

Dear All,
We have been using an Excel file as datbase for document merging for a
couple years. Everything worked fine until I received a brand new
Office 07/Win Vista machine.

Now mailmerging works, but it does not seem to fetch the data from the
same file as the one I see when I open Excel. ie I add lines in Excel
and save the document, but Word does not see them.

I had that sort of troubles with ini files ni Program Files Directory,
but I don't see why Vista would make a local copy of a file stored on
the network.

Any idea / hint ? Thanks in advance !

BR,
Damien

Reply to this Message

Peter Jamieson - 23 Oct 2007 11:17 GMT

I've seen the general kind of thing you are talking about on Word 2007 (I
don't think Vista is the problem here) but not when I create a new .xlsx,
put it on a network drive, and use it as a data source using the default
connection method (OLE DB). So I wondered...
a. are you working with an existing .doc and .xls from an earlier version
of Word or
b. are you working with completely new .docx and .xlsx files from Office
2007 (and if not, and you experiment using that, do you see the problem?)
c. some other combinaiton of .doc, .docx, .xls, .xlsx etc.?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Dear All,
> We have been using an Excel file as datbase for document merging for a
[quoted text clipped - 13 lines]
> BR,
> Damien

Reply to this Message

Ciegalo - 23 Oct 2007 16:04 GMT

On 23 oct, 12:17, "Peter Jamieson" <p...@KillmapSpjjnet.demon.co.uk>
wrote:

> I've seen the general kind of thing you are talking about on Word 2007 (I
> don't think Vista is the problem here) but not when I create a new .xlsx,
[quoted text clipped - 5 lines]
> 2007 (and if not, and you experiment using that, do you see the problem?)
> c. some other combinaiton of .doc, .docx, .xls, .xlsx etc.?

Hi,
Thanks for your reply.

I'm using .doc and .xls that were created using Office 2K or XP. .*x
are not compatible enough (colors, pivot tables).

Your message rings a bell as you mention OLE. I need to check, but the
connection might be DDE. Could that be a problem ?

BR,
Damien

Reply to this Message