Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem Merging Field with text & numbers
I have an Excel File. It contains a column labeled "Room"
It has entries such as: D213 C314 315 A316 When I try to merge it, the only one that merges properly is the one without any letters. The rest say just say 0. I tried formatting the cell in Excel so that they are text, but that didn't make any difference. How can I fix this? Thanks, Glenn |
#2
|
|||
|
|||
From the Tools menu in Word, select Options and then go to the General tab
and check the box against "Confirm conversions at open" After doing that, when you attach the data source to the mailmerge main document, you will be presented with a number of options for the way in which the connection should be made. Try the DDE option. -- 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 "Glenn" wrote in message ... I have an Excel File. It contains a column labeled "Room" It has entries such as: D213 C314 315 A316 When I try to merge it, the only one that merges properly is the one without any letters. The rest say just say 0. I tried formatting the cell in Excel so that they are text, but that didn't make any difference. How can I fix this? Thanks, Glenn |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert source texts into multiple files and update automatically | Microsoft Word Help | |||
HTML text in Merge Field | Mailmerge | |||
Having multiple form fields automatically updated | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help | |||
textbox to normal text | New Users |