davec8723
01-21-2011, 04:32 AM
Hi,
I have a question which I hope someone can help me with. There are approximately 10 files which I update on a monthly basis. After I complete this update, each file is sent out to 5-20 unique recipients. I use LOTUS NOTES as my e-mail client.
I am wondering if there is a way to use VBA, to assign a button to send the active workbook to a list of e-mail addresses. The list of e-mail addresses will be on a sperate worksheet inside the workbook which I would like to send.
Therefore, I could add the destination e-mail addresses once to the workbook, and simply click a button to e-mail that open workbook to the intended recipients monthly!
If anyone can help me out with this I would greatly apprecaite it. I have VERYYY limited code experience, so please try to dumb it down a little if you could.
Thank You!
Dave
I have a question which I hope someone can help me with. There are approximately 10 files which I update on a monthly basis. After I complete this update, each file is sent out to 5-20 unique recipients. I use LOTUS NOTES as my e-mail client.
I am wondering if there is a way to use VBA, to assign a button to send the active workbook to a list of e-mail addresses. The list of e-mail addresses will be on a sperate worksheet inside the workbook which I would like to send.
Therefore, I could add the destination e-mail addresses once to the workbook, and simply click a button to e-mail that open workbook to the intended recipients monthly!
If anyone can help me out with this I would greatly apprecaite it. I have VERYYY limited code experience, so please try to dumb it down a little if you could.
Thank You!
Dave