mail merge and excel data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sherobot - 23 Apr 2007 15:20 GMT

I have an excel sheet that has numbers calculated on it and I'm bringing
those numbers into a word doc by using a mail merge. Does anyone know how to
make the numbers have the correct formatting (i.e. $12,876.00) once it merges?
Or can you tell me how to change the formatting using fields once the data
has been merged?
Thanks

Reply to this Message

Peter Jamieson - 23 Apr 2007 16:23 GMT

Usually you can use Alt-F9 to display the field code, e.g.

{ MERGEFIELD myamount \*Mergeformat }

and add a numeric "format switch", e.g.

{ MERGEFIELD myamount \#"$,0.00" \*Mergeformat }

Then Alt-F9 again to reveal the result, and if necessary, slect the field
and press F9 to update it.

Peter Jamieson

>I have an excel sheet that has numbers calculated on it and I'm bringing
> those numbers into a word doc by using a mail merge. Does anyone know how
[quoted text clipped - 4 lines]
> has been merged?
> Thanks

Reply to this Message

sherobot - 23 Apr 2007 20:08 GMT

That worked great, thank you!

> Usually you can use Alt-F9 to display the field code, e.g.
>
[quoted text clipped - 17 lines]
> > has been merged?
> > Thanks

Reply to this Message