Merging from Excel to Word
I am having a lot of trouble merging from an Excel file into word with
Microsoft Word 2003. Believe it or now, we just upgraded to that a couple
months ago, and ever since, I have had nothing but trouble with it. The main
problems a
1) When I try to merge just the newest data from the spreadsheet into a
letter (first of all, there are not the user-friendly query options there
were in my old 2000 version), I tell Word to merge from line 2140 to line
2170. It actually merges from line 2141 to 2171, so I end up missing my
first line of data and having a blank line of data at the end. So to get the
result I want, I have to tell it to merge from line 2139 to 2169.
2) The other problem I'm having is that when I try and select those same
lines for making labels, instead of being able to type in the range of lines,
it pulls up the whole spreadsheet and I have to scroll to the bottom and
individually check each item that I want to merge into labels. After I do
that slow process, it often still merges the whole spreadsheet in to labels
instead of the 20-40 or so items that I have painstakingly checked
individually!
If anyone has any suggestions, I'd really appreciate it! This is something
I've done weekly for a couple months now with nothing but trouble, and I have
to continue doing it weekly.
|