C
cottage6
Hello everyone,
I'm trying to help a user with a mail merge I believe was originally done in
Word 2000; current user has 2002 with Excel 2002. It seems I have 2
different problems:
1) There are 4 "percent" fields, percent1 - percent4. Looks to me like
percent1 has been used for all 4, so I need to change the last 3 fields. In
Step 4 of the merge I've been clicking on "More items" and selecting the
percent2, percent3, and percent4 fields that way.
2) The percent fields are formatted as percent with 0 decimals in Excel.
When the merge occurs the actual value of the cell is what shows in Word. I
tried to edit the field using Ctrl + F9 with this code { ={ Mergefield
percent2 }*100 \#0%}. I am getting an !Undefined Bookmark error when I do
the merge.
Any ideas? I don't know what to do. TIA
I'm trying to help a user with a mail merge I believe was originally done in
Word 2000; current user has 2002 with Excel 2002. It seems I have 2
different problems:
1) There are 4 "percent" fields, percent1 - percent4. Looks to me like
percent1 has been used for all 4, so I need to change the last 3 fields. In
Step 4 of the merge I've been clicking on "More items" and selecting the
percent2, percent3, and percent4 fields that way.
2) The percent fields are formatted as percent with 0 decimals in Excel.
When the merge occurs the actual value of the cell is what shows in Word. I
tried to edit the field using Ctrl + F9 with this code { ={ Mergefield
percent2 }*100 \#0%}. I am getting an !Undefined Bookmark error when I do
the merge.
Any ideas? I don't know what to do. TIA