mail merge

[Kerry]

Can I mail merge an extensive list of doctors (with
addresses and phone#'s) on a Word document to an excel
spreadsheet? If so, how do I do this? If I can't
accomplish this task by mail merge is there another
function to merge my addresses onto excel?

 

[EZ Money]

Save the Word document as a .txt file and open it with XL. Follow the
wizard.

 

[David McRitchie]

Hi Kerry,
Your question is unclear. Mail Merge is strictly for printing in
MS Word from data obtained from a data base. Excel is a data base
as far as the Mail Merge operation is concerned.

Your wording is confusing. if the one list is just doctors then
the other must have everything. If you do not have data in two places
then I think you better look up the word "merge" so we can be talking
about the same thing. Possibly you mean transfer or export if there
is only one list, in which case copy and paste to Excel would be all you
need..

If you data is in Word you will have to paste it into an Excel worksheet
to merge data. This is an Excel newsgroup.

I think you have a list of doctors with some additional information and wish
to include still more additional information from another list that has some
common reference point like doctor's name. (Must be thousands of
doctors with the same name).

You can add additional information using VLOOKUP see
http://www.mvps.org/dmcritchie/excel/vlookup.htm
Then you can put your more comprehensive list back to Word.

-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm