Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge processes only 2 records
Somehow the mailmerge processes only 2 records when I use
MailMergeBeforeRecordMerge event. In my main document I've got two tables with each a bookmark. In the MailMergeBeforeRecordMerge event I want to populate this tables with data: lstraFields = Split(lstrInvalidDoc, "||") For lnIndexFields = 0 To UBound(lstraFields) lstrField = lstraFields(lnIndexFields) With doc.Bookmarks(pstrTableName).Range.Tables(1) .Cell(.Rows.Count, lnIndex).Range = lstrField End With Next But somehow due to this insertion of the cell the mailmerge stops after two records. If I remove the insertion of the cell and then loop through the code with breakpoints, all records are processed. Any ideas? Kind regards, Jeroen Walstra |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge processes only 2 records
Hi ?B?SmVyb2Vu?=,
Somewhere, you have a line of code that contains mailmerge.Execute. The Execute method has a Pause argument. Try setting this to FALSE. Somehow the mailmerge processes only 2 records when I use MailMergeBeforeRecordMerge event. In my main document I've got two tables with each a bookmark. In the MailMergeBeforeRecordMerge event I want to populate this tables with data: lstraFields = Split(lstrInvalidDoc, "||") For lnIndexFields = 0 To UBound(lstraFields) lstrField = lstraFields(lnIndexFields) With doc.Bookmarks(pstrTableName).Range.Tables(1) .Cell(.Rows.Count, lnIndex).Range = lstrField End With Next But somehow due to this insertion of the cell the mailmerge stops after two records. If I remove the insertion of the cell and then loop through the code with breakpoints, all records are processed. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge processes only 2 records
Hi Cindy
I've tried to set Execute to False, but then only one record seems to be merged and it creates a second blank page... I'm really stuck on this issue, so I hope you've got some more ideas. Jeroen Walstra "Cindy M -WordMVP-" wrote: Hi ?B?SmVyb2Vu?=, Somewhere, you have a line of code that contains mailmerge.Execute. The Execute method has a Pause argument. Try setting this to FALSE. Somehow the mailmerge processes only 2 records when I use MailMergeBeforeRecordMerge event. In my main document I've got two tables with each a bookmark. In the MailMergeBeforeRecordMerge event I want to populate this tables with data: lstraFields = Split(lstrInvalidDoc, "||") For lnIndexFields = 0 To UBound(lstraFields) lstrField = lstraFields(lnIndexFields) With doc.Bookmarks(pstrTableName).Range.Tables(1) .Cell(.Rows.Count, lnIndex).Range = lstrField End With Next But somehow due to this insertion of the cell the mailmerge stops after two records. If I remove the insertion of the cell and then loop through the code with breakpoints, all records are processed. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mailmerge from Access parameter query only merges odd records | Mailmerge | |||
Help! Mailmerge code for all selected records? | Mailmerge | |||
Included Property in Word 2003 MailMerge | Mailmerge | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge | |||
mailmerge records missing at pageskip | Mailmerge |