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.
|