Format from Excel not being shown in mail merge

MS WORD

    Next

  • 1. email merge DSL connection
    I am unable to do an email merge. It goes through all the steps and acts like it is sending as it flashes as it steps trough each address. It does the same thing with a datebase or Outlook adresses. I didn't try it when I had dial up or Cable, howver a bulk email program I used before with both won't work with DSL and there support refers me to vendor who does not support anymore. -- Phil Berndt Torrance,CA
  • 2. printing multiple envelopes in word
    Is it possible to print multiple envelopes with the same addressee at one time? I want to print a dozen envelopes for one client when opening a new business file. I cannot find a way to do this in word.
  • 3. Word Mailmerge vs WP mail merge
    I'm used to WP mail merge where a [KEYBOARD] is entered. In the merge, the document stops at this KEYBOARD so that info can be added. I can't find where this is possible in Word. Is it possible and if so, how?
  • 4. Line Break in a simple label mail merge
    I am trying to use Word & Excel to merge for a mass mailing (labels). Using the address block works fine, but I had to insert a database field for a 3rd address line from the db. This also work ok, except that address line 3 ends up on the same line as the city & postal code etc. Is there a way to force a line break to separate address 3 if it prints? Thanks

Format from Excel not being shown in mail merge

Postby Helen » Fri, 11 Nov 2005 03:46:47 GMT

Hi,

I have created a mail merge in Word from an Excel spreadsheet.  The
spreadsheet contains social security numbers that are stored as numbers
999999999 but formatted as 999-99-9999.  When doing the mail merge Word will
display the SSN as 999999999, not as 999-99-9999.  How can I fix this?

Thanks!!

Helen



Re: Format from Excel not being shown in mail merge

Postby Doug Robbins - Word MVP » Fri, 11 Nov 2005 04:06:57 GMT

Add the following formatting switch inside the closing } of the mergefield. 
Use Alt+F9 to toggle the display of the field codes.

\# "###'-'##'-'####"

For example

{ MERGEFIELD SSN \# "###'-'##'-'####" }

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








Re: Format from Excel not being shown in mail merge

Postby Helen » Fri, 11 Nov 2005 04:14:41 GMT

Works great!

Thanks!!

Helen





mergefield.






Similar Threads:

1.Excel text not showing in Word mail merge

Using 2003; have a spreadsheet I have used in a Word mail merge.  One column 
of the xls file is for the grade of school student is in (1, 2, 3, 4, K, P1, 
P2).  When viewing the xls file in Word, the column is showing the 1, 2, 3, 
and 4 but is putting 0 for the K, P1 and P2.  I've tried changing the xls 
file formating on the column to General and Text but nothing seems to help.

2.Excel field does not show up as entered when doing mail merge

Using Office 2002. Data in Excel field is a number, a dash, and a letter, ie:4509-C.  When merged for labels the data does not show up.  A "0" appears.  I have formatted the Excel field as General, Number, and Text with the same results.  Also, when a field is blank, the "0" appears in the Word document field.  I've never had this problem before.  

3.Mail Merge - My excel document does not show up under browse

When I try to mail merge from excel to word my excel sheet does not show up 
under browse.  I know this must be very simple but I need help please.  
Simply trying to print labels from my excel sheet.

4.Excel 2007 not retaining formatting in mail merge operation

I am trying to do  merge document with excel and word 2007 and the zip codes 
drop the first zero, 01234 becomes 1234. I have tried formatting the cells 
with ALL the choices to no avail. Please help!!!

5.Mail Merge with Excel - Date not Formatting Correctly

Hello,

I am having some issues with my Mail Merge. I am using Word and Excel
2003.  I am bringing over some dates from Excel into Word using Mail
Merge. The format I would like to see for example, is April 7, 2007.
I have numerous dates that are tying into this Word document and I
have added the switch \@ "MMMM d, yyyy" to all of the MERGEFIELDS and
they are working fine, except for one. I get the serial date of 39179.
I have added the switch, deleted it, closed, opened, updated fields
etc.. to see if it will register but to no avail. I know Excel and
Word are communicating because when I change the date in Excel, the
serial date in Word changes to match. It is only this one cell that is
not working in this document. Any suggestions would be greatly
appreciated.

Thank you in advance for your time.

Dan

6. Mail merging a date from excel, appears as US format not UK

7. Mail merge does not keep formatting from excel into word document

8. Why Word 2007 mail merge does not retain number format from Excel



Return to MS WORD

 

Who is online

Users browsing this forum: No registered users and 9 guest