How do I import data from excel to do a mail merge in word?

[Guest]

My husband has an excel spreadsheet that he is wanting to merge into Word to
make labels. I used to know how to do this but I have forgotten. Can anyone
help me?

 

[Guest]

This site will show how to use multiple types of data sources for your
labels, with Excel being one of them:

http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

 

[Guest]

This Excel workbook may add to what Microsoft has to say - it shows the
process with pictures and discussion in it:
http://www.jlathamsite.com/Teach/WordMailMergeWithExcelDataSource.xls

 

[Guest]

I went to this website, and the process is different from what I'm dealing
with. It prompts me to "Select Table" two times, and then tells me that word
cannot open the data source. Can you tell me how to get word to open the
data source (excel file) for mailing labels?

 

[Gord Dibben]

Mary

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

I went to this website, and the process is different from what I'm dealing
with. It prompts me to "Select Table" two times, and then tells me that word
cannot open the data source. Can you tell me how to get word to open the
data source (excel file) for mailing labels?

Gord Dibben MS Excel MVP

 

[Guest]

None of these sources tell me how to get word to open the source. I have the
excel files set up exactly like the examples and yet it still cannot open it.
What could be the problem?

 

[Gord Dibben]

Mary

Do you get any message when you try to open the source?

Have you got an Excel driver listed in your Data Sources(ODBC) in Control Panel?

Should be there but maybe you have to add it.


Gord