Hi All
I am trying to send copyies of 2 different Daily reports to 2 email groups.
1st email group get's sheet 13 of the workbook and the second email group
get's the whole workbook. I have entered the email addresses on a sheet and
when I click on one it auto opens new mail. What I would like is to have a
macro that will add an attachment of a specific sheet to that email and
insert the subject, so all the operator has to do is click send on the new
mail.
It also needs to be the actual workbook that is open at the time as we save
a new report each day, therefore working on a different workbook each day.
what I have so far is cell S9 has the 1st group of emails and cell S15 has
the other group.Is there a simple way to do this.
Regards
Chris

Hi again
Is it also possible to activate the "new mail" with the use of a command
button. I have one that can select the cell but it dosen't activate the
email. I can put a button in for each email group/attachment.

Thanks
Chris

"Chris" wrote:

Hi All
I am trying to send copyies of 2 different Daily reports to 2 email groups.
1st email group get's sheet 13 of the workbook and the second email group
get's the whole workbook. I have entered the email addresses on a sheet and
when I click on one it auto opens new mail. What I would like is to have a
macro that will add an attachment of a specific sheet to that email and
insert the subject, so all the operator has to do is click send on the new
mail.
It also needs to be the actual workbook that is open at the time as we save
a new report each day, therefore working on a different workbook each day.
what I have so far is cell S9 has the 1st group of emails and cell S15 has
the other group.Is there a simple way to do this.
Regards
Chris

Hi again, again.
Ihave found a macro that will do what I was trying

"Chris" wrote:

Hi again
Is it also possible to activate the "new mail" with the use of a command
button. I have one that can select the cell but it dosen't activate the
email. I can put a button in for each email group/attachment.

Thanks
Chris

"Chris" wrote:

Hi All
I am trying to send copyies of 2 different Daily reports to 2 email groups.
1st email group get's sheet 13 of the workbook and the second email group
get's the whole workbook. I have entered the email addresses on a sheet and
when I click on one it auto opens new mail. What I would like is to have a
macro that will add an attachment of a specific sheet to that email and
insert the subject, so all the operator has to do is click send on the new
mail.
It also needs to be the actual workbook that is open at the time as we save
a new report each day, therefore working on a different workbook each day.
what I have so far is cell S9 has the 1st group of emails and cell S15 has
the other group.Is there a simple way to do this.
Regards
Chris