View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP- Cindy M  -WordMVP- is offline
external usenet poster
 
Posts: 370
Default 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 :-)