S
Steve S.
Hello,
I had an (Office XP) Access application that merged data from tables with
multiple Word documents. After SP3 was installed, the part of the code that
does the merging does not work.
Here is the trouble spot:
When stepping thru this code CGDocMerge.State = 2
and wdMainAndDataSource = 0, so the code never excecutes, and data is not
merged with my templates.
wrdCGDoc1.Documents.Open FileName:="C:\Additional
Info\Letters\LetterTemplates\" &
KindOfLetter & ".doc"
wrdCGDoc1.Visible = True
Set CGDocMerge = wrdCGDoc1.ActiveDocument.MailMerge
If CGDocMerge.State = wdMainAndDataSource Then
With CGDocMerge
.DataSource.FirstRecord = intCounter
.DataSource.LastRecord = intCounter
.DataSource.ActiveRecord = intCounter
.Execute
End With
All was good until SP3 came along.
Thanks in advance,
Steve S.
I had an (Office XP) Access application that merged data from tables with
multiple Word documents. After SP3 was installed, the part of the code that
does the merging does not work.
Here is the trouble spot:
When stepping thru this code CGDocMerge.State = 2
and wdMainAndDataSource = 0, so the code never excecutes, and data is not
merged with my templates.
wrdCGDoc1.Documents.Open FileName:="C:\Additional
Info\Letters\LetterTemplates\" &
KindOfLetter & ".doc"
wrdCGDoc1.Visible = True
Set CGDocMerge = wrdCGDoc1.ActiveDocument.MailMerge
If CGDocMerge.State = wdMainAndDataSource Then
With CGDocMerge
.DataSource.FirstRecord = intCounter
.DataSource.LastRecord = intCounter
.DataSource.ActiveRecord = intCounter
.Execute
End With
All was good until SP3 came along.
Thanks in advance,
Steve S.