Merging Excel Data into Word Document

  • Thread starter Thread starter Marty
  • Start date Start date
M

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
 
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.
 
Back
Top