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

Computer - Excel Mail Merge - Writeacher, Friday, July 4, 2008 at 9:35am
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.
Computer - Excel Mail Merge - SraJMcGin, Friday, July 4, 2008 at 9:56am
Thank you for using the Jiskha Homework Help Forum. No promises, but the first Tutorial may help:

1. http://mistupid.com/technical/mailmerge/

2. http://www.internet4classrooms.com/msword_formletter.htm

3. http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

4. http://wordprocessing.about.com/od/usingmailmerg1/l/blexcelmerge2.htm

5. http://www.j-walk.com/ss/excel/tips/tip92.htm
- Computer - Excel Mail Merge - Lamp, Sunday, July 6, 2008 at 10:02pm
  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?

Answer this Question

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 ...
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 ...
computer education - e-mail is electronic mail sent through the computer? true ...
computer - When creating a mail merge to send out a form letter, where should ...

For Further Reading

First Name:
School Subject:
Answer: