Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to get special mailmerge with word
- Thread starter Nifrabar
- Start date
It may be easier use something like "FRX2WORD" (do a Google) to print a VFP grouped data report to a Word document rather than use automation.
-Dave Summers-
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
Even more Fox stuff at:
-Dave Summers-
Even more Fox stuff at:
Mike Lewis
Programmer
Bart,
The answer doesn't really have anything to do with Word.
Just create a temporary table which incorporates the grouping (using SELECT ... GROUP BY ... INTO ...), and use that as the data source for the mailmerge.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
My Visual FoxPro site: www.ml-consult.co.uk
- Thread starter
- #4
Hi Dave and Mike,
It seems I have not been clear enough.
Hereunder is the link to Tamar's paper I supposed to use as start-point. It describes, among very much other wearthful 'automation matters' how to use word's mailmerge wizzard from within VFP.
But as far as I know content of records of a datasource are transfered so that data of one record is transferred to a single sheet.
In my situation I want to group people, living at the same addres, and put their figures together on a single sheet.
I learned from Tamar to use a dedicated Word-template so my end-user might change kind of body-text in the mailing. Meanwhile I do the automation for the data-input from within fox. That's the reason I am considering to do th eoutput using automation and word.
Hopes this clarifies my needs.
-Bart
It seems I have not been clear enough.
Hereunder is the link to Tamar's paper I supposed to use as start-point. It describes, among very much other wearthful 'automation matters' how to use word's mailmerge wizzard from within VFP.
But as far as I know content of records of a datasource are transfered so that data of one record is transferred to a single sheet.
In my situation I want to group people, living at the same addres, and put their figures together on a single sheet.
I learned from Tamar to use a dedicated Word-template so my end-user might change kind of body-text in the mailing. Meanwhile I do the automation for the data-input from within fox. That's the reason I am considering to do th eoutput using automation and word.
Hopes this clarifies my needs.
-Bart
TamarGranor
Programmer
Word can't handle a one-to-many relationship in mail merge. You'll have to find a way to flatten that out.
However, there is a type of mail merge called a "catalog," where you can put data from multiple records on a single page. You'd use it, for example, to create a phone directory. You might be able to do what you want with a loop that pulls data for one parent into a cursor and uses that for a mail merge.
Tamar
However, there is a type of mail merge called a "catalog," where you can put data from multiple records on a single page. You'd use it, for example, to create a phone directory. You might be able to do what you want with a loop that pulls data for one parent into a cursor and uses that for a mail merge.
Tamar
- Status
Similar threads
- Question