Gord I followed the procedures you gave in the URL but my Word program could
not open the Excel file. What did I do wrong. I set the Excel file up as text
as you said and then pasted data from a Works data base into it. Is that my
problem? Am i going to have to retype the whole thing?
--
thriftyjohn


"Gord Dibben" wrote:

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

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

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben Excel MVP

On Tue, 24 Aug 2004 08:25:12 -0700, straitfan
wrote:

We have an excel spreadsheet with names and addresses in columns. We would
like to manipulate this data (without having to retype it) in a Word document
for a class reunion project to read like this:
Jane Doe
xxx street
xxx city, state, zip
Comment line: Jane has been a teacher for........

Any ideas?

Ralph

Other than providing several helpful sites on Mailmerge I did not "tell you"
to do anything.

I would first copy the data from Works into an Excel workbook, manipulate
that data into the proper format...........outlined in any of the sites
posted.........then save the workbook.

Now open Word and start the mailmerge steps pointing to the Excel workbook.

Good luck.


Gord

On Sun, 23 Nov 2008 08:25:01 -0800, Ralph wrote:

Gord I followed the procedures you gave in the URL but my Word program could
not open the Excel file. What did I do wrong. I set the Excel file up as text
as you said and then pasted data from a Works data base into it. Is that my
problem? Am i going to have to retype the whole thing?