Mail Merge/HELP!!!

F

Frances

I have received a very large Excel spreadsheet that needs to be set up for a Word mail merge....it was set up something like thi

CompanyName Contact Name Title Contact Address, and so on
Test Susie Mgr Smith Driv
Test Mike Spvr Jones Driv
Test Henry Spvr Henry Stree
Spex Mary Mgr Harvey R
Spex etc...

Is there a way for me to have the letter go to the Mgr and cc the Spvrs (with different addresses) without creating or making huge changes to the existing spreadsheet
 
M

mark

If you only need to print certain, or all, fields, you do
not have to do a mail merge.

A macro can do it.

If you would like to send me a dummy sheet, about five
rows, I might be able to do it.

I will need exact tiles and positions but not the private
data anda couple of days.

Otherwise, open Word and Insert > Object > create from
file.

-----Original Message-----
I have received a very large Excel spreadsheet that needs
Click to expand...
to be set up for a Word mail merge....it was set up
something like this
CompanyName Contact Name Title Contact Address, and so on.
Test Susie Mgr Smith Drive
Test Mike Spvr Jones Drive
Test Henry Spvr Henry Street
Spex Mary Mgr Harvey Rd
Spex etc....

Is there a way for me to have the letter go to the Mgr
Click to expand...
and cc the Spvrs (with different addresses) without
creating or making huge changes to the existing
spreadsheet?
 
D

Dave Peterson

This might not work for you.

But since I don't do mailmerges too often, I'd copy that worksheet and put my
supy's names in cells on the same row as the manager's name. (And delete the
supy's row.)

Then use that sheet for mailmerge.
 
Top