View Single Post
  #3  
Old April 29th, 2010, 08:14 PM posted to microsoft.public.word.mailmerge.fields
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default How do I create a data source within an excel document?

EXCEL 2007

Here is a simple example:-

1. In cells A1 to F1 enter the following:

Title
FirstName
LastName
Address1
City
Country

The above are your column headers (these must agree with your WORD
corresponding fields).

2. In A2 to F2 enter the following:-

Mrs.
Michelle
Ambrose
145 Napoleon Avenue
Sanderstead
England

3. Then for additional rows enter the information that you want to.

If the above helps please hit Yes.

Thanks.




"Tracy" wrote:

I am trying to do a mail merge with Word and Excel. It tells me to select a
data source, but not how to create one in Excel.