Macro Problem sending Worksheet by email

[charliefunkuk]

I have such an annoying problem.

Please look at my attached excel spreadhseet.

Click on the "Materials" worksheet and on there you will see an email button.
When I press it, it runs a macro to email the worksheet "Supplier Matl 1" to all the suppliers listed on worksheet "Aluminium Suppliers". The macro is called "Email_Macro". If you look at the Macro you will see I have a line which says:-

Please Login or Register  to view this content.

I want it to add all the addresses in cells C3 to C5 from sheet Aluminium Suppliers into the BCC of the email.

the problem is it does not work as its meant to, but f I just put C3 then the email in C3 goes into the BCC field perfectly fine, but doing a range it doesnt work.

Does anybody know why??

Please help, its driving me nuts!!

Neil

[Leith Ross]

Hello Neil,

Both the CC and BCC fields are strings. To include more than one person you must separate the email addresses with a comma.

Please Login or Register  to view this content.

Sincerely,
Leith Ross