how do I insert excel data into a word database

[murf]

I have entered a vast amount of data into an Excel worksheet and would like
to now use Word to mail merge. How do I transfer that Excel data to Word
without having to retype everything

 

[Richard O. Neville]

It is not necessary to transfer any data. Word will merge easily (better, I
think) from an Excel document. When you are prompted in the mail merge to
select a data source, just go to the Excel sheet and click on it as the
source, then follow the directions in the mail merge.

You do have to insert headings in the Excel columns, such as FirstName,
Address, Zip so Word will recognize them. Also, my experience is that
merging works more easily when the Excel doc is closed, not open.

 

[well wisher]

-----Original Message-----
I have entered a vast amount of data into an Excel worksheet and would like
to now use Word to mail merge. How do I transfer that Excel data to Word
without having to retype everything
.

Open you word document..like on Tools.....options....
click on general.......check on box which says confirm
conversionon open.

Now start doing mailmerge..
go to tools.....letters and mailings... mail merge wizard
rightside of your screen mailmerge taskpane appears.
click on first radio button which says letters
then in thr down click on starting document.
click on first radio button which says use an existing
document.
then click on select recipents.
Now click on Browse and locate you excel data file.
confirm conversion box appears in that select MS EXCEL VIA
DDE.
click on ok on next window with all data source.
click on write your letter ....start typing your letter.
then click on More option
Insert field you want to use for merge.
then arrange the fields.
click on preview your letter, it shows how your letter
looks like after merge.
Now click on complete the merge.
This will merge your document using excel data source.

If this works out for you, please dont forget to mail me
back
Have a nice day.
bye
wellwisher.