Peter,

thank you for replying.

i have merged a general word letter with my contact list (from excell). I
now need to personalize these letters with the value of their costs (FYE).
this is in another excell spreadsheet.
however the trick is that this list of people with costs is not as complete
as my word contacts. so i also need to ensure the merge can recognise the
costs to the right contact! my only other option is to do this indiviually!

Help!!

"Peter Jamieson" wrote:

can i do this?

Only by cut-and-pasting a lot.

would i need to go back into excell and put
the two differnt spreadsheets into one book?

It sounds like you may need to do something like that, but it depends on
exactly what you need to do. If your contact list is already in one
spreadsheet, and your sepearte spreadsheet has one row for each contact, and
you can sort the two so they are in the same sequence, then you can probably
just copy the column(s) you need from the "values" sheet into the contacts
sheet and use that to do a new mailmerge based on your existing mail merge
main document. Otherwise I think it would be helpful if you could say more
about your two data sources.

Peter Jamieson

"mbtn" wrote in message
...
I would like to add 'values' or costs from a seperate spreadsheet to an
already mail merged document (contact list merge). can i do this? how? or
would i need to add a 'tag' of some sort to insert values? This document
i
merged is over 300 word pages! would i need to go back into excell and put
the two differnt spreadsheets into one book?

i am not a I.T person at all and would appreciate any help.

Thank You.