Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rob Klaassen ( Rob Klaassen ( is offline
Posts: 1
Default Mail Merge Documents created Dynamically through Visual Foxpro 8/9

Hi All

I have a mail merge document created in Word (XP) which has a DDE connection
to an Excel spreadsheet generated through code by a Foxpro program.

We have now updated to Office 2007and every time I do a mail merge and open
the files through VFP I get an ' external table not in the expected format'.
The files are stored on the server.

However, when I create the same files on the local machine and open the
files using VFP it seems to work.

Sometimes it is a matter of reconnecting the datasource other times it takes
3-4 times to reconnect.

I have gone into the Tools section and ticked Confirm file format conversion
on open

I do not want my users to have to reconnect to the datasources everytime.
This used to work on previous version on Office.

Has anyone come across this problem before?

Any suggestions on how to fix this or provide a workaround?


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamically formatting text color in mail merge xray Mailmerge 4 May 11th 23 02:51 PM
Word 2000 mail merge created documents also opens Excel data sourc Nancy 2glow Mailmerge 1 May 1st 08 07:58 PM
word 2003 mail merge using foxpro 9 tables as a data source fails Daniel Williams Microsoft Word Help 16 January 31st 08 05:18 PM
mailmerge and Visual Foxpro Mark Mailmerge 4 February 24th 06 05:09 AM
Saving all individual documents created by a mail merge iuwonny Mailmerge 0 February 15th 06 08:16 AM

All times are GMT +1. The time now is 07:43 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"