Wednesday
August 27, 2014

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

word processing - How do you merge documents (from a table into a word document ...
computer - The merge process involves two types of files, namely, A. mail merge ...
word. - What are the three sections of the Mail Merge Helper dialog box?
adult education - 19. When using mail merge, the part that contains variable ...
power point - 19. When using mail merge, the part that contains variable ...
IT - In this assignment, you are going to be gathering information about the ...
computers ( basics) - I was wondering I have an Excel project that needs to be ...
computer - When creating a mail merge to send out a form letter, where should ...
computers - what term is given to pieces of computer software that allow you to ...
computer education - e-mail is electronic mail sent through the computer? true ...

Search
Members