Mail Merge?

[mbtn]

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.

 

[Peter Jamieson]

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]

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]

If it's a one-off, frankly, your best bet is to insert the values manually,
even though there are a lot of them. Another approach if there are not many
rows "missing" from your second sheet would be to add the missing rows, sort
both sheets and combine them. Anything else is probably going to require
that you do a lot of steps you may never have done before.

I don't know Excel well enough to tell you whether or not there is an easy
way to combine your values into a single sheet - I would ask in an Excel
group. However you do it, to do it "automatically", your data will need a
column in each sheet with a common identifier, e.g. perhaps you have a
contact ID or name column that contains the same data for matching rows in
the two sheets. If I were doing it, I'd probably just import the data into
Access and create a query that joins the two tables. But maybe you don't
have Access. In that case, if MS Query is installed on your system (it is
optionally installed when you run Office setup) you should be able to open a
new spreadsheet, go into the Excel Data menu and use Import External
Data|New Database Query. You would then need to work out how to define a
query involving your two sheets (which MS Query sees as "tables") ,
"joining" them using the common identifier column. Then save that sheet and
use it as your merge source.

Peter Jamieson

 

[Peter Jamieson]

One of Doug Robbins' messages has reminded me - in Excel you could play
around with the LOOKUP function to try to splice your two sheets together -
if you need more help on that, you really do need to ask in an Excel group.

Peter Jamieson