Merging Excel Data into Word Document

To mark specific records for merging, you could add a column to your
table in Excel, and use an IF formula. For example,

=IF(A2="","X","")

would return an if cell A2 is blank.

For details on merging with Word, see David McRitchie's web site:

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

Also, there's information on the Word MVP site:

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


Marty wrote:
I have a large spreadsheet in Excel. I want to merge the data from page
three (3) of the data base (excel) into several Word documents. I
currently merge the data from a Word Data File. That causes me to have
to update Word and Excel each time there is a change in status.

All like information (such as names, address, phone number, etc) is in
its own column on page three which was pulled from my original data
from page one of the spreadsheet. There are several formulas on page
three maniuplating numbers from page one.

I want to change data only one time and update all pages of the
spreadsheet (which I can already do), but also update the data for
merging into four (4) separate merge documents.

I would also like to select just certain fields to merge by using an
"if,then" statement, and printing a letter to only some of the names if
their circumstances require communication. Can you help me?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Marty,
Filtered lists are a powerful tool for selecting which records
you want to include with Copy and Paste and also for such
things as rows accepted into Mail Merge. I think that is what
Debra was starting to mention, You will find mention of
filtered lists on my page that Debra gave you. Debra has
pages on Advanced Filtering, but Auto Filter was what I think
was being lead into.
---
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

"Debra Dalgleish" wrote in message
To mark specific records for merging, you could add a column to your
table in Excel, and use an IF formula. For example,

=IF(A2="","X","")
would return an "X" if cell A2 is blank.

For details on merging with Word, see David McRitchie's web site:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also, there's information on the Word MVP site:
http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm