Thread: Mail Merge
View Single Post
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

Hi Kath-

In the Excel file, are both first name & last name contained in a single
column? If so, that is the problem. Each item _must_ be stored in a separate
'field' (column).

HTH |:)

"Kath" wrote:

Hi,

I am using Word 2002 with the XP operating system at one computer lab and
Word 2003 with the XP operating system at another lab. When I try to do a
mail merge to create letters, using a list of recipients on an Excel
spreadsheet, I am not getting the results I expected as follows:

1. For the Address Block, I asked the Mail-Merge Wizard to set up my letters
with this formatting: Mr. Joe Becker. However, in the letter, it appeared
without the salutation with this formatting: Joe Becker. (The address, town,
state and zip appeared correctly.)

2. For the Greeting Line, I asked the Mail-Merge Wizard to set up my letters
with this formatting: Dear Mr. Becker. However, in the letter, it appeared
with this formatting: Dear Joe Becker.

Do you have any idea why this is happening and how I could fix it?

I look forward to your response. Thanks!