Word Merge Formatting Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSalant - 14 Apr 2008 17:21 GMT

Using Office 2007, when I do a mail merge using Excel as the data source. The
numbers I have in the spread sheet with $ signs or decimial points in Excel
are removed once the merge is complete in Word. Is there as setting I can use
to ensure that formatting is retained? For ex.... $15.00 will merge into
the doc as 15

HELP!!!

Thanks
Mike

Reply to this Message

Doug Robbins - Word MVP - 14 Apr 2008 21:00 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Using Office 2007, when I do a mail merge using Excel as the data source.
> The
[quoted text clipped - 9 lines]
> Thanks
> Mike

Reply to this Message

MSalant - 15 Apr 2008 00:50 GMT

Doug........Thanks!!!!!!!!!!!!

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 14 lines]
> > Thanks
> > Mike

Reply to this Message