Wednesday
March 4, 2015

Homework Help: Computer - Excel Mail Merge

Posted by Lamp on Friday, July 4, 2008 at 4:17am.

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

computer - The merge process involves two types of files, namely, A. mail merge ...
word processing - How do you merge documents (from a table into a word document ...
adult education - 19. When using mail merge, the part that contains variable ...
power point - 19. When using mail merge, the part that contains variable ...
word. - What are the three sections of the Mail Merge Helper dialog box?
IT - In this assignment, you are going to be gathering information about the ...
computer - When creating a mail merge to send out a form letter, where should ...
Beta - What does beta mean in terms of overall risk to a company? What are the ...
media - 1. When you link a worksheet and a chart in a business report as well as...
computers - . When you link a worksheet and a chart in a business report as well...

Members