Reply
 
Thread Tools Display Modes
  #1   Report Post  
Shawna
 
Posts: n/a
Default Formatting using Excel datasource for mail merge

I know how to insert a €œnon-breaking space€ into a word/phrase in WORDTM to
keep it from breaking (^s). However, if Im 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


  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"Shawna" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Formatting zip code in mail merge from Excel to Word Zip code help Microsoft Word Help 1 February 10th 05 01:50 AM
How do I merge an excel document Pat McGlamery Tables 1 December 10th 04 03:00 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 02:11 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"