Automatic Emailing via Macro

[hcabs99]

All

Some advise please, i am looking to automate the sending of various spreadsheet via an excel macro, but there are 2 things i am stuck on:


1 The Macro, takes a master sheet, runs various filters and opens up documents to paste the filtered data in, i would like to be able to rename each of these documents and save them as the new name. These i then email to a predefined group of addresses

2) I can get as far as creating the email with an attachment in , i dont know how to automatically add in the receipiants

Any advise?

Cheers

 

[texasalynn]

are the recipients listed in your file? I do this by referencing the cell address, example

.To = Cells(2, 9)
.CC = Cells(2, 10)

 

[hcabs99]

Thanks for the response, however im not clear on how to imbed this within the code

Currently the email send part of the code reads

"Application.Dialogs(xlDialogSendMail).Show"

How do i add the email addresses from the workbook?

Also, can you help re the renaming of sheets upon save please?

Cheers