Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Deanna Deanna is offline
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Excel text not showing in Word mail merge

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Deanna wrote:
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.



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 excel to word text Emily Mailmerge 3 December 4th 08 05:22 PM
MS Word Mail Merge from Excel -- Force Excel to open the datafile? [email protected] Mailmerge 6 September 26th 08 03:08 PM
Mail merge data not showing on Mail Recipient List Connie G Mailmerge 6 October 26th 06 04:17 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
Mail merge from Excel to Word, keeping $ and cents in text Dakota Microsoft Word Help 1 December 7th 05 04:57 PM


All times are GMT +1. The time now is 12:22 AM.

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"