G
Gareth Roberts
Hi,
I've trawled through the NGs but can't seem to find anyone who's come across
this - which surprises me. Maybe I'm missing something obvious.
I have a mail merge document (Word 2000 - must be good for 97 too) which has
a single field data source in an Excel workbook. When the document is opened
it also opens it the source workbook. So far so good.
Should the user add another record below the existing fields, say in row 6,
this will not be mail merged - even though the "Entire Spreadsheet" is set
as the range. I have got around this in VBA by getting Excel and thence the
workbook as an object, saving it, closing it and reopening. Strikes me as
rather convoluted. Is there a way of programmatically forcing Word to
refresh its source range?
Thanks for any help,
Gareth
I've trawled through the NGs but can't seem to find anyone who's come across
this - which surprises me. Maybe I'm missing something obvious.
I have a mail merge document (Word 2000 - must be good for 97 too) which has
a single field data source in an Excel workbook. When the document is opened
it also opens it the source workbook. So far so good.
Should the user add another record below the existing fields, say in row 6,
this will not be mail merged - even though the "Entire Spreadsheet" is set
as the range. I have got around this in VBA by getting Excel and thence the
workbook as an object, saving it, closing it and reopening. Strikes me as
rather convoluted. Is there a way of programmatically forcing Word to
refresh its source range?
Thanks for any help,
Gareth