mailmerge and Visual Foxpro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 22 Feb 2006 15:51 GMT

Hi,
I connect to a VFP Database via ODBC DSN and open the requested table. The
data is displayed in its natural order. I click on the name field to have the
order set to "name". I return to my mailmerge lables and save my word.doc.
Next time when I open the doc, the data is displayed in natural order again
and I have to repeat the silly task of setting the wanted order.
Any hint.
Thank you
Mark

Reply to this Message

Doug Robbins - Word MVP - 22 Feb 2006 18:38 GMT

I don't know anything about VFP, but if you were using Access, I would
suggest creating a Query in which the data was sorted by the Name field and
use the Query as the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
> I connect to a VFP Database via ODBC DSN and open the requested table. The
[quoted text clipped - 7 lines]
> Thank you
> Mark

Reply to this Message

Mark - 23 Feb 2006 10:01 GMT

Hi Doug,
Well that would be double work! No other hint?
Thanks
Mark

> I don't know anything about VFP, but if you were using Access, I would
> suggest creating a Query in which the data was sorted by the Name field and
[quoted text clipped - 11 lines]
> > Thank you
> > Mark

Reply to this Message

Doug Robbins - Word MVP - 24 Feb 2006 05:09 GMT

I am not sure that it would be double work. It would only have to be done
one time.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi Doug,
> Well that would be double work! No other hint?
[quoted text clipped - 20 lines]
>> > Thank you
>> > Mark

Reply to this Message

Peter Jamieson - 23 Feb 2006 10:38 GMT

Which version of Word? Which SP?

Which version of the VFP driver (you cna find out in the ODBC
administrator).

Are you connecting to a DBF that you select in "Select Data Source", or a
dbc?

Can you open the visual basic editor and in the immediate window type

print Activedocument.Mailmerge.Datasource.Querystring

and post the results here? If so, it would help if you could post the result
a. before you sort
b. immediately after you sort
c. after you close and re-open the document

The value of ActiveDocument.Mailmerge.Datasource.connectstring would also be
useful.

If you are using Word XP, attempting to see those values may crash Word, in
which case, you may be able to see what query Word is using by
a. saving as a Web page, complete and closing
b. checking Word Tools|Options|General|Confirm Conversions at open
c. opening the .htm file you saved, specifying plain text when the
converter dialog box comes up (or ignore (b) and just open the .htm file in
Notepad)
d. finding the block of Datasource information and extracting the query
string and connect string from there.

Peter Jamieson

> Hi,
> I connect to a VFP Database via ODBC DSN and open the requested table. The
[quoted text clipped - 7 lines]
> Thank you
> Mark

Reply to this Message