L
Lesley Canuckie
I'm having a really weird experience with doing a mail merge! I'm using an
excel 2003 file from another user, which is e-mailed to me. I actually use
Excel 97! We have validated that the data is the same on both of our copies.
I am merging using Word 2002.
I have 3 situations ... one is an address that was at one time on the
spreadsheet, but which is now removed (the cell is blank!), the other is an
address that has changed, and the 3rd is a Canadian Postal Code in the Zip
code column.
When I merge, the blank address actually merges and shows the ORIGINAL
address that was in the cell instead of leaving it blank, the other address
shows the ORIGINAL address that was in that cell (not the new address), and
the postal code returns "0", despite the fact that I am merging using the DDE
selection in merge. There is another postal code which is merging correctly.
All columns are formatted as text.
Can anyone help??
Thanks,
Lesley
excel 2003 file from another user, which is e-mailed to me. I actually use
Excel 97! We have validated that the data is the same on both of our copies.
I am merging using Word 2002.
I have 3 situations ... one is an address that was at one time on the
spreadsheet, but which is now removed (the cell is blank!), the other is an
address that has changed, and the 3rd is a Canadian Postal Code in the Zip
code column.
When I merge, the blank address actually merges and shows the ORIGINAL
address that was in the cell instead of leaving it blank, the other address
shows the ORIGINAL address that was in that cell (not the new address), and
the postal code returns "0", despite the fact that I am merging using the DDE
selection in merge. There is another postal code which is merging correctly.
All columns are formatted as text.
Can anyone help??
Thanks,
Lesley