Post a New Question

Computer - Excel Mail Merge

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. word processing

    How do you merge documents (from a table into a word document for example)?
  2. IT

    In this assignment, you are going to be gathering information about the future students of NSU at one of our open houses. Since there will be plenty of student candidates with interests on different programs, I would like you to create …
  3. microsoft excel 2003

    How would I graph equations in Microsoft Excel 2003 and the residuals?
  4. computers ( basics)

    I was wondering I have an Excel project that needs to be done I have MSW 2007 and the school uses MSW 2003 are the compatibly or is the a way for me to get MSW 2003 ( of course keeping my MSW 2007) and not messing up my computer thanks
  5. word.

    What are the three sections of the Mail Merge Helper dialog box?
  6. power point

    19. When using mail merge, the part that contains variable information such as names and addresses is called the A. merge fields. C. merged document. B. main document. D. data source. 20. Options for designing the way text and graphics …
  7. adult education

    19. When using mail merge, the part that contains variable information such as names and addresses is called the A. merge fields. C. merged document. B. main document. D. data source. 20. Options for designing the way text and graphics …
  8. computer

    The merge process involves two types of files, namely, A. mail merge template and mailings. B. primary and secondary. C. text and merge fields. D. main document and data source. 20. The Word feature you can use to add formatting to …
  9. Algebra

    12. Determine if the following is a conjuction or disjunction. y + 4 < -1 or y + 2 > 8 (Points : 1) 13. State how you determined if the combination above was a conjunction or disjunction. (Points : 2) 14. Solve the problem. (Hint: …
  10. computer

    The merge process involves which two types of files?

More Similar Questions

Post a New Question