Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Percentage some formatting correct some not
I'm mail merging from excel to word and my percentages are sometimes turning
out correct...if there was a value in the excel spreadsheet. For those fields that did not have a value in it, I'm receiving a syntax error. I'm using this formula to get this far: { ={ MERGEFIELD percent }*100 \#0% } Help??? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Percentage some formatting correct some not
Try
{ IF { MERGEFIELD percent } "" { = { MERGEFIELD percent } * 100 \# 0% } "" } That would return nothing if there is no value in the field. If you wanted 0% to appear in the case of an empty percent field, then insert a 0% in place of the "" before the final field delimiter. -- 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 "kimhr" wrote in message ... I'm mail merging from excel to word and my percentages are sometimes turning out correct...if there was a value in the excel spreadsheet. For those fields that did not have a value in it, I'm receiving a syntax error. I'm using this formula to get this far: { ={ MERGEFIELD percent }*100 \#0% } Help??? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage mail merge | Mailmerge | |||
Mail Merge Percentage | Mailmerge | |||
Merge with Percentage field looses formatting | Mailmerge | |||
Mail Merge - Excel Percentage changes | Mailmerge | |||
Formatting a percentage mail merge field | Microsoft Word Help |