J
Jim Hahn
I am doing a simple mail merge. Word document is the
master document. An excel file contains information to
be merged into the word file. Each row in the excel
file is one person's name, address, etc. I have about
150 names to process.
When I start the mail merge function, to a file, all
works well. After about 20 seconds, the temp file
pops up with all the individual form letters properly
filled in.
The problem: The mail merge function keeps running
after it finishes merging my 150 names. I have a
SKIPIF operator to check if my name field is blank,
so that prevents Word from outputting a dummy form
letter for a blank row.
But how do I tell Word/Excel that there ain't any more
real data rows in my Excel spreadsheet? Word keeps
spending cpu time in the background running through
thousands and thousands of empty rows, doing nothing.
This can take 5 minutes.
Isn't there some code or operator I can put in the last
row of the spreadsheet to terminate things?
Thanks,
--jim
(e-mail address removed)
master document. An excel file contains information to
be merged into the word file. Each row in the excel
file is one person's name, address, etc. I have about
150 names to process.
When I start the mail merge function, to a file, all
works well. After about 20 seconds, the temp file
pops up with all the individual form letters properly
filled in.
The problem: The mail merge function keeps running
after it finishes merging my 150 names. I have a
SKIPIF operator to check if my name field is blank,
so that prevents Word from outputting a dummy form
letter for a blank row.
But how do I tell Word/Excel that there ain't any more
real data rows in my Excel spreadsheet? Word keeps
spending cpu time in the background running through
thousands and thousands of empty rows, doing nothing.
This can take 5 minutes.
Isn't there some code or operator I can put in the last
row of the spreadsheet to terminate things?
Thanks,
--jim
(e-mail address removed)