Mail Merge Formatting

  • Thread starter Thread starter AJOLSON
  • Start date Start date
A

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
 
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.
 
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

NetworkTrade said:
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


AJOLSON said:
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
Click to expand...
Click to expand...
 
Back
Top