| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Database Mail Merge with Currency!
I would appreciate some advice on using an existing database to complete a
mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
The merge doesn't bring over the formatting. Use a switch on the mergefield
eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
Graham - many thanks for this, what a speedy response! got it to work no
problem. Thanks again Wendy "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
Graham,
I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
If you want the decimals displayed, you need to add the decimal point and
the zeros to the switch \# "0.00%" -- 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 "Marge" wrote in message ... Graham, I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
Doug,
No, I'm trying to get the three places to the LEFT of the decimal. I get 1.00% instead of 100.00%. A number that was 80.00% in my spreadsheet comes out as 0.80% in my letter. I would make them "text" in my spreadsheet, except the percents are used in calculations, and then the rest of the spreadsheet is "wrong". I tried the {={MERGEFIELD *FTE*} *100 \"0.00%"}, but I get a "syntax error" in place of the merge field and there is no change. I would appreciate any help!!! "Doug Robbins - Word MVP" wrote: If you want the decimals displayed, you need to add the decimal point and the zeros to the switch \# "0.00%" -- 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 "Marge" wrote in message ... Graham, I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
A P.S. to my previous post, my MergeField name IS in quotes, not the asterik
- I just typed it wrong {={MERGEFIELD "FTE"}*100 \# "0.00%"}...sorry! "Marge" wrote: Doug, No, I'm trying to get the three places to the LEFT of the decimal. I get 1.00% instead of 100.00%. A number that was 80.00% in my spreadsheet comes out as 0.80% in my letter. I would make them "text" in my spreadsheet, except the percents are used in calculations, and then the rest of the spreadsheet is "wrong". I tried the {={MERGEFIELD *FTE*} *100 \"0.00%"}, but I get a "syntax error" in place of the merge field and there is no change. I would appreciate any help!!! "Doug Robbins - Word MVP" wrote: If you want the decimals displayed, you need to add the decimal point and the zeros to the switch \# "0.00%" -- 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 "Marge" wrote in message ... Graham, I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
You don't need the quotes around FTE, but you do need to press CTRL+F9 for
each pair of field brackets if you are entering the fields directly. This is what you should have {={MERGEFIELD FTE} * 100 \# "0.00%"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org . Marge wrote: A P.S. to my previous post, my MergeField name IS in quotes, not the asterik - I just typed it wrong {={MERGEFIELD "FTE"}*100 \# "0.00%"}...sorry! "Marge" wrote: Doug, No, I'm trying to get the three places to the LEFT of the decimal. I get 1.00% instead of 100.00%. A number that was 80.00% in my spreadsheet comes out as 0.80% in my letter. I would make them "text" in my spreadsheet, except the percents are used in calculations, and then the rest of the spreadsheet is "wrong". I tried the {={MERGEFIELD *FTE*} *100 \"0.00%"}, but I get a "syntax error" in place of the merge field and there is no change. I would appreciate any help!!! "Doug Robbins - Word MVP" wrote: If you want the decimals displayed, you need to add the decimal point and the zeros to the switch \# "0.00%" -- 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 "Marge" wrote in message ... Graham, I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
I have it right now. Thank you all for hanging in there with me and making
this work! "Graham Mayor" wrote: You don't need the quotes around FTE, but you do need to press CTRL+F9 for each pair of field brackets if you are entering the fields directly. This is what you should have {={MERGEFIELD FTE} * 100 \# "0.00%"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org . Marge wrote: A P.S. to my previous post, my MergeField name IS in quotes, not the asterik - I just typed it wrong {={MERGEFIELD "FTE"}*100 \# "0.00%"}...sorry! "Marge" wrote: Doug, No, I'm trying to get the three places to the LEFT of the decimal. I get 1.00% instead of 100.00%. A number that was 80.00% in my spreadsheet comes out as 0.80% in my letter. I would make them "text" in my spreadsheet, except the percents are used in calculations, and then the rest of the spreadsheet is "wrong". I tried the {={MERGEFIELD *FTE*} *100 \"0.00%"}, but I get a "syntax error" in place of the merge field and there is no change. I would appreciate any help!!! "Doug Robbins - Word MVP" wrote: If you want the decimals displayed, you need to add the decimal point and the zeros to the switch \# "0.00%" -- 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 "Marge" wrote in message ... Graham, I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
|
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Database Mail Merge with Currency!
What would we do without people like Graham? I have spent about 3 hours
trying to do what the simple line below states and do you know what I was doing wrong? I didnt push ctrl f9 twice!! One would have thought MS would be clever enough to put it into the Bl**dy help files!!! Thank you Graham for keeping worldwide sanity! "Graham Mayor" wrote: You don't need the quotes around FTE, but you do need to press CTRL+F9 for each pair of field brackets if you are entering the fields directly. This is what you should have {={MERGEFIELD FTE} * 100 \# "0.00%"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org . Marge wrote: A P.S. to my previous post, my MergeField name IS in quotes, not the asterik - I just typed it wrong {={MERGEFIELD "FTE"}*100 \# "0.00%"}...sorry! "Marge" wrote: Doug, No, I'm trying to get the three places to the LEFT of the decimal. I get 1.00% instead of 100.00%. A number that was 80.00% in my spreadsheet comes out as 0.80% in my letter. I would make them "text" in my spreadsheet, except the percents are used in calculations, and then the rest of the spreadsheet is "wrong". I tried the {={MERGEFIELD *FTE*} *100 \"0.00%"}, but I get a "syntax error" in place of the merge field and there is no change. I would appreciate any help!!! "Doug Robbins - Word MVP" wrote: If you want the decimals displayed, you need to add the decimal point and the zeros to the switch \# "0.00%" -- 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 "Marge" wrote in message ... Graham, I have already laminated a copy of your site on Formatting Word Fields with Switches, sigh. But I have one that I can't get to work. I have an Excel S/Sheet with Column formatted as 100.00% (84.00%, 45.00%, etc., etc.). I need to Merge it into my Word document in that format, but I can only get it to come in without zeros or percent sign(i.e. 100.00% comes in as a "1" ). I have tried the following switches - nothing works: {MERGEFIELD "FTE" \# "0%"} AND {={MERGEFIELD "FTE"} *100\# "0%"} as you recommeded in your article. I can't get it to do anything but the number "1" all by itself. Is there any chance they are going to "fix" this mail merge formatting business in Office 2007(12)? I can't imagine that my office users are the ONLY ones who hate it! Thank you for your help! "Graham Mayor" wrote: The merge doesn't bring over the formatting. Use a switch on the mergefield eg {Mergefield fieldname \# "£,0.00"} see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org WendyMc wrote: I would appreciate some advice on using an existing database to complete a mail merge. The database has a currency field, but when I attach this to my letter all formatting is lost - £23,000 becomes 23000. Is there a simple reason for this? Any help would be fab. Many thanks in advance Wendy |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update fields of mail merge based on lookup to database | Mailmerge | |||
| Word 2003 Mail Merge from Excel spreadsheet database | Mailmerge | |||
| Form Letter Mail Merge using field code: {Database} | Mailmerge | |||
| Include Cc: details on merged letters using mail merge database or fields? (not email Cc:) | Mailmerge | |||
| mail merge with attachments | Mailmerge | |||
Linear Mode
