I have a problem when doing the mail merge with Office 2003.
First of all, I wrote a letter in Word 2003 and then try to merge some data from Excel 2003. The data in Excel column was listed as below:
A1=101
A2=123
A3=134
A4=148A
A5=181B
Problem:
The data of A4 & A5 in recipient list are changed to 0 instead of the original ones.
Question:
How can I show "148A" and "181B" in Word 2003 (recipient list) when mail merging with such data?
(I've tried to add ' in front of those data in order to convert them into TEXT format, it works. But I have too many data to make it by manual.
Do you have any other solution instead?)
I've never had success using the mail merge with Word and Excel, so I would press the F1 key in each program, find the directions for mail merge, and print the directions out. Then I'd try again.
Thanks for both of your help.
It is quite confusing.
It becomes normal when I do it at home.
It means that the problem is not happened in computer A but B.
(Is it a setting Problem, if yes, how to solve it pls?)
My friend advise me to add ' in front of the data. It works.
But I have a lot of data, it is quite hard to add it one by one, do you have any other idea?
To show the values "148A" and "181B" correctly in the Word 2003 mail merge, you can follow these steps:
1. Open the Excel 2003 file containing the data you want to merge with Word.
2. Select the entire column that contains the data you want to merge (in this case, column A).
3. Right-click on the selected column and choose "Format Cells" from the context menu.
4. In the "Format Cells" dialog box, go to the "Number" tab.
5. Select "Text" from the Category list.
6. Click on the "OK" button to apply the formatting.
By applying the "Text" formatting to the column in Excel, the values will be treated as text during the mail merge process in Word. This will prevent any unintentional formatting or changes, such as converting "148A" to 0.
After performing these steps, you can proceed with the mail merge in Word as usual, and the values should be displayed correctly in the recipient list.
Note: It's important to format the cells in Excel as text before performing the mail merge. If you have already performed the merge and are experiencing issues, you may need to restart the mail merge process, ensuring the formatting is correct in Excel before proceeding.