S
Sean
On my Win98 machine I had a word doc merging data drawn
from an Excel s'sheet with macros making use of filters
to generate new docs dependent on a filter condition.
This generated code within the macro thus:
ActiveDocument.MailMerge.DataSource.QueryString = _
"SELECT * FROM C:\My Documents\Clients\Client
Bible.xls WHERE ((PROPOSED_ = 'Bromley')) ORDER BY
VISSEQ" _
& ""
I have tried to replicate in Word 2003 on my new PC (XP
home) and this code (and only this code) is missing from
the macro. This means that the newly generated docs draw
from the filter last saved on the base word doc and not
applying the changes dictated by the macro and the doc is
useless.
Have tried applying the code manually to no avail. Any
clues anyone?
from an Excel s'sheet with macros making use of filters
to generate new docs dependent on a filter condition.
This generated code within the macro thus:
ActiveDocument.MailMerge.DataSource.QueryString = _
"SELECT * FROM C:\My Documents\Clients\Client
Bible.xls WHERE ((PROPOSED_ = 'Bromley')) ORDER BY
VISSEQ" _
& ""
I have tried to replicate in Word 2003 on my new PC (XP
home) and this code (and only this code) is missing from
the macro. This means that the newly generated docs draw
from the filter last saved on the base word doc and not
applying the changes dictated by the macro and the doc is
useless.
Have tried applying the code manually to no avail. Any
clues anyone?