Mail Merge and email separate named files

[stroffso]

Hi all,
I have a mail merge list (tabname "Datasheet" which runs a mail merge fine however I want to add a few extra steps which I cant appear to be able to do in word.

As well as sending to one person I want to CC a number of other people (based on column J in the datasheet). Also I would then like to PDF the letter and email it all in one go but also have some standard text in the body of each email (also pulling from the Datasheet tab).

Does anyone know if this is possible?

I was thinking rather then using word maybe doing up the letter in an Excel tab and then have some form of looping code to PDF the letter and then email it which would also be fine I just dont know where to start, any advice is greatly appreciated,

thanks

 

[stroffso]

So i have worked out a way to PDF the files automatically, just need to work out the emailing bit now