Mail Merged from Excel but no % sysmbol

[Guest]

I viewed the help in another posting and tried it. It solved the problem of
hainalm the decimals but I need it to dispay as 75% not 0.75.

Here's what I have in Word 2003 document: {MERGEFIELD "Van"*100\#"0%"}
Souce document shows in cell 75% and is formatted as a percentage with no
decimals.

Merged results: Van 0.75
Desired results Van 75%

Can anyone help?

 

[Suzanne S. Barnhill]

See http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Thanks for the link but I am already there and have typed exactly what it
staess;
Percentages:

Frequently, percentages will display as decimals - eg 41% from the data may
display as 0.41354836739 when merged into Word. To display the decimal as a
percentage, you should create a calculated field eg:

{={MERGEDFIELD Amount} *100\#"0%"}

It would not work with the 1st {= in place, so I removed it and left the
rest of the formula the same. It did remove the decimals but still displays
as .75% instead of 75%. If this isn't possible can someone tell me it is or
not as I have read through the very link you gave me. I've been working on
this for a couple of hours.

 

[Beth Melton]

Personally I just use the DDE method to connect to the Excel data if I
want the formats to be included.

- Go to Tools/Options/General
- Turn on "Confirm Conversion at Open"
- Select your mail merge data source again
- When prompted select the DDE method

This should pick up the number formatting in your workbook instead of
the data as it is stored.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Guest]

Beth I went into Tool Options and General and selected Confirm Conversion at
Open but it did not ask me anything except for how many records I wanted to
merge.
The checkis in the box for this item but its not asking me anything about a
method of conversion.

 

[Beth Melton]

Did you select your mail merge data source again? Once you have a
connection to your data source then you need to reconnect it in order
to select a different connection method.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Graham Mayor]

The = (formula) field is required. Did you insert the field boundaries with
CTRL+F9 and did you update the field F9, and I hope your spelling mistake
didn't make its way into the field As you have not multiplied by 100 the
decimal is now in the wront place.

{={Mergefield Amount} * 100 \# "0%"}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Thank you soooooooo very much. Often I do read the articles, but its
nothiong like ole fashion step by step answers! Have a blessed week.

 

[Guest]

If you enter the calculated field as follows Crl F9 to obtain the first {}
then type = between the bracket followed by another Crl F9 {={}} next type
MERGEDFIELD Amount between the enclosed brackets. followed by * 100 \#"0%.
It important you don't input the brackets from the keyboard Hope this is
some help
Bob Fortune

 

[Graham Mayor]

You have a typo there Bob - it should be MERGEFIELD.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

cheers Graham i should have read your reply as you have already given the
solution.