>When using Word for Mail Merge I have been using a table as the data source for documents.....is there an alternative source (cursor etc) I could use?
>
>The reason is this:
>
>networked app for medical records where individual users need to access patient records and mail merge their details to letters etc in Word. Up to now, I have used a table located on each user's hard drive (c:\ipletters\letm.dbf) to store merge data just in case more than 1 user tries to store merge data at the same time - which precludes one table on the network drive.
>
>So - if users could access a patient's record, store their name and address details in a temporary medium, and use this as the data source for Word, this would avoid each user having to have their own LETM.dbf on their hard drive.
>
>Any ideas gratefully received!
>
>Bob
Word can read from a DBF - but it has to be dBASE format, not FoxPro. I assume the table can be either on a local disk, or on a shared folder.
You can also export from VFP to some other formats, like delimited, which should be accepted by Word.
Another possibility is to insert data from VFP into a Word document (preferably, a table), through Automation.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)