Formatting using Excel datasource for mail merge

S

Shawna

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
 
D

Doug Robbins

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

\@ "MMMM d"

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top