Hello All,
I would like to find some code that will allow me to send each separate worksheet in a workbook to a separate email address (located in Cell D2 of each sheet) using Microsoft Outlook. Attached is a bare bones sample workbook with two sheets, but the actual book will have around 300 sheets. I am hoping someone can help me out by providing advice, coding, or suggestions for where to look for an answer.
Thank you,
Ryan
Last edited by rss12321; 08-23-2012 at 02:06 PM.
Hello rss12321,
Welcome to the Forum!
Did you want the worksheet mailed as an attachment or included it in the email body?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
Thank you for your response. I would prefer to have the sheets mailed as attachments if possible. Thanks!
Hello rss12321,
Copy and paste this macro into a new module in your workbook's VBA Project.
Please Login or Register to view this content.
Last edited by Leith Ross; 08-23-2012 at 02:55 PM.
Hello,
Thank you again for your help. Unfortunately, when I try to run this macro I receive the error message (on my excel file):
"The following features cannot be saved in macro-free workbooks:To save a file with these features, click No and then choose a macro-enabled file type in the File Type list.
- VB Project
To continue saving as a macro-free workbook, click Yes."
If I click yes, the VBA editor produces the error message "Run-time error '1004':
Method 'Saveas' of object'_worksheet' failed"
If I click no and attempt running the macro in a macro enabled file type, the same error(s) occur.
Do you have any thoughts on this issue? Thanks!
Hello rss12321,
Sorry for the late reply. I had to leave unexpectedly to answer a client's request. You probably need to enable macros in Excel. Here is link on how to do that...
Change Macro Security Settings In Excel 2007
Also, this version of the macro will handle most common Excel file formats. You may want to use this version instead of the previous one.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks