Mail Merge Formatting

[AJOLSON]

I am having a problem keeping formatting after a mail merge has completed.
Here is the issue.

I have formatted in access a field as a percent. In access I see 50%. But
when I mail merge it, to a word document reads .50 does anyone know how to
make word read as 50%?

Thanks’
Andy

 

[NetworkTrade]

the table is actually holding the value of .50

if you are at the beginning of the project and this is a new table - and you
are flexible with this field.....(that's alot of "ifs"....) you can redefine
that field as a text field and then enter 50% and it will appear in your
mail merge as 50% because it is just text...

if you can't mess with table's field and those values then it is a little
trickier. one method maybe is a macro command in Word - but I can't help you
with that and you might need to go to the Word forum for assist...

another approach is to make the Merge sourced on a query and in the query do
a conversion with a calculated field i.e. NewPercent:
[OldPercentField]*100
this will change it from .5 to 50 and then you can put the % symbol in
the text of the letter.

 

[Peter Hibbs]

Andy,

You could format the field in the Word document to display it how you
want. See :-
http://word.mvps.org/FAQs/MailMerge/index.htm
for more details.

HTH

Peter Hibbs.

 

[AJOLSON]

Man sometiems when you look at a problem to long you can't see how simple the
solution is.

I built a function to change .50 to 50% and send it back to the Query as
text then append the table as text and poof works great!!!!!! Go figure.
Thanks for the tip.

Andy

the table is actually holding the value of .50

if you are at the beginning of the project and this is a new table - and you
are flexible with this field.....(that's alot of "ifs"....) you can redefine
that field as a text field and then enter 50% and it will appear in your
mail merge as 50% because it is just text...

if you can't mess with table's field and those values then it is a little
trickier. one method maybe is a macro command in Word - but I can't help you
with that and you might need to go to the Word forum for assist...

another approach is to make the Merge sourced on a query and in the query do
a conversion with a calculated field i.e. NewPercent:
[OldPercentField]*100
this will change it from .5 to 50 and then you can put the % symbol in
the text of the letter.
--
NTC

I am having a problem keeping formatting after a mail merge has completed.
Here is the issue.

I have formatted in access a field as a percent. In access I see 50%. But
when I mail merge it, to a word document reads .50 does anyone know how to
make word read as 50%?

Thanks’
Andy