Computer - Excel Mail Merge
posted by Lamp .
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:
The data of A4 & A5 in recipient list are changed to 0 instead of the original ones.
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.
Thank you for using the Jiskha Homework Help Forum. No promises, but the first Tutorial may help:
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?