Merging Excel Data into Word Document

[Marty]

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

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

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

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

 

[Debra Dalgleish]

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/MailMerge/CreateAMailMerge.htm

 

[David McRitchie]

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.