Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2005

Tip: Looking for answers? Try searching our database.

Loosing SSN number format after mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 16 Feb 2005 22:53 GMT
Hi,

I'm using Office 2003 and have, what I hope to be, a simple question.

My data is in an Excel file.  I have a list of ssn numbers with a "special"
format selected to display them correctly. i.e. 123456789 is displayed as
123-45-6789.

When I do the mail merge into Word it looses this formatting, I'm assuming
because word sees it as a number and not text?

Is there a way around this or do I have to update all my ssn numbers in
excel to text?  If I just change the format to text, then I'll loose the
"-". I rather not re-type everything.

Thanks,

Lisa
Peter Jamieson - 16 Feb 2005 23:30 GMT
Three things you can try:
a. as you suggest, change the data format to text and re-enter the data, or
transform the data you have into a format containing the "-" characters. I
suspect this is likely to be the best bet longer term.
b. connect to the data source using DDE - this requires that you have
\Excel on your system. Check Word Tools|Options|General|Confirm conversions
at open, then go through the connection process again and select the DDE
option when offered. This is the way Word used to connect by default in Word
2000 and earlier.
c. try using a numeric format switch in Word. This will only work if
   - the number format is very consistent
   - the number of digits is not too large

e.g. instead of

{ MERGEFIELD ssn }

try

{ MERGEFIELD ssn \#"000'-'00'-'0000" }

Peter Jamieson
> Hi,
>
[quoted text clipped - 14 lines]
>
> Lisa
Lisa - 17 Feb 2005 15:15 GMT
H Peter,

I tried the DDE and it worked great.

Thanks!

Lisa

> Three things you can try:
> a. as you suggest, change the data format to text and re-enter the data,
[quoted text clipped - 36 lines]
>>
>> Lisa
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.