Formatting using Excel datasource for mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shawna - 25 Feb 2005 14:33 GMT

I know how to insert a “non-breaking space” into a word/phrase in WORDTM to
keep it from breaking (^s). However, if I’m doing an EXCELTM spreadsheet that
is a merge list, how do I designate that I want a date that is being inserted
not to break?

For example:

January 28th
In my letter, because of the merge field «CAMPUS_DATE», the date is breaking
so that January is on one line and the 28th follows on the next line. I would
like it to wrap and take the January 28th as one item.

Anyone know?

Thank you in advance for any suggestions.

Shawna

Reply to this Message

Doug Robbins - 26 Feb 2005 00:19 GMT

Add a formatting switch to the mergefield with a non breaking space between
the month and the day

\@ "MMMM d"

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I know how to insert a "non-breaking space" into a word/phrase in WORDTM to
> keep it from breaking (^s). However, if I'm doing an EXCELTM spreadsheet
[quoted text clipped - 17 lines]
>
> Shawna

Reply to this Message