#1
|
|||
|
|||
Mail Merge help
Hello,
I am trying to do a mail merge. I created my label in Word and want to bring in my information from Excel. I have currency fields in my excel spreadsheet that read $00.00 but when I merge them to my labels they come out $00.0000. Is there anyway to merge them and keep the format I want? HELP! Thanks in advance! Dawn |
#2
|
|||
|
|||
Yes, you can modify the filed the way that you want.
After insertint the fields in the wor document You can modify by Press Alt+F9, it will display the field codes like {MERGEFIELD “Currency”} You can modify it by using "\#,##,###.00" and keep on adding the digits and decmals as you like as shown below. {MERGEFIELD\#,##,###.000 “Currency”} Try this out and let me know if you have any questions. Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge | hiteshkataria | Mail Merge | 4 | 11-06-2009 05:11 AM |
Mail Merge Problem | JohnRG | Mail Merge | 0 | 11-02-2009 02:50 AM |
mail merge | Anthony | Outlook | 1 | 09-29-2009 06:09 PM |
Mail Merge | Mohanss82 | Mail Merge | 0 | 01-21-2009 12:29 PM |
Mail Merge Query | kangabanga | Mail Merge | 0 | 09-25-2008 04:07 AM |