If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mailmerge - Replace fields and formatting
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 |
#2
|
|||
|
|||
Mailmerge - Replace fields and formatting
Does the { MERGEFIELD percent2 } alone result in a number being displayed?
Did you use Ctrl+F9 for both pairs of field delimiters { } Make sure that you have a space either side of the * operator and between the # and the 0 { = { Mergefield percent2 } * 100 \# 0% } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "cottage6" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|