Tuesday
March 28, 2017

Post a New Question

Posted by on .

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

Answer This Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Post a New Question