Code to attach a sheet as an Outlook email attachment

**rlsublime** · 11-30-2011, 08:35 AM

Is there a way to attach an excel sheet and send it to email addresses in a workbook?

Thanks

**Domski** · 11-30-2011, 09:12 AM

Hi,

Have a look here: http://rondebruin.nl/sendmail.htm

Dom

**rlsublime** · 11-30-2011, 09:22 AM

Thanks, the code here worked but I am trying to edit it so that only certain names will be emailed. for example if toms and jims names are in a range then i want them to be emailed or if Bill,Jack, and Mark are in the range then I want them to be emailed. Is there a way to edit the code to achieve this. Thanks

Please Login or Register  to view this content.

**Domski** · 11-30-2011, 09:50 AM

Is it always a specific sheet you want to email and where would the list of people to send it to be kept?

Dom

**rlsublime** · 11-30-2011, 10:20 AM

Here is the sample file. Basically, if there are any names in the yellow dropdown boxes, then I am trying to get an email to be sent to those names. Just the active "email" Sheet ould need to go out and the names and email addresses are in the Sheet3 tab.

Thanks for the help

**Domski** · 11-30-2011, 11:01 AM

Try the attached.

I changed the named range for your validation list from name to empnames as Name is a reserved word in Excel I think and could have caused problems.

Dom