Preserve format of data in Excel when doing a mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louise - 13 Jan 2008 09:26 GMT

I am using Office 2007 and am trying to do a mail merge using data from an
Excel spreadsheet. I have a 'Salary' field in Excel with the data formatted
in the £ currency style e.g. £30,000.00 but when I merge the data, I lose the
formatting. How can I keep the formatting in the same way as it is displayed
in Excel?

Signature

Thanks, Lou

Reply to this Message

Graham Mayor - 13 Jan 2008 09:37 GMT

Word does not import Excel formatting.Use a currency formatting switch on
the field. http://www.gmayor.com/formatting_word_fields.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am using Office 2007 and am trying to do a mail merge using data
> from an Excel spreadsheet. I have a 'Salary' field in Excel with the
> data formatted in the £ currency style e.g. £30,000.00 but when I
> merge the data, I lose the formatting. How can I keep the formatting
> in the same way as it is displayed in Excel?

Reply to this Message