"Send Active Workbook to list" macro

[omarq]

I'm using the following Macro to automatically send the active workbook via email to a list of recipients. I want to modify it so that it distributes the file to a list of email addresses that are stored in a closed workbook. The closed workbook would have be as follows:

.To the list would be in column A
.CC the list would be in column B
.BCC the list would be in column C

I'm having trouble getting this to work.... can somoene point out how I should reference these in the macro?

Thanks in advance

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[omarq]

thanks - i'm not sure how this references the closed workbook? could you please clarify?
Thanks!

[snb]

Which closed workbook ?

[omarq]

sorry - i should have been more clear...

the lists would be contained within a closed workbook for example

c:\folder1\folder2\distribution_list.xls

[snb]

Please Login or Register  to view this content.

[omarq]

Thats great - thanks