I don't even know if this is possible, but it would be great. I have a workbook that I split into multiple worksheets by employee name. So, one tab would be John Smith, another would be Suzy Smith, and so on. I'd like to be able to automate the sending of these tabs to those people, but I have no idea how to go about it. I can also create separate workbooks from these tabs, so that there is a workbook to attach if necessary. I am using Office 2010, FYI.
Hello Andy,
Welcome to the Forum!
This macro will compare the worksheet name to the contact names in your Outlook Contacts folder. The name must be First Name, Space, Last Name.
If a sheet name matches a contact, it is then emailed to the person. The workbook information is sent in the body of the email.
Add a new VBA Module to your workbooks VBA project and paste this code into it. You can then run the macro by choosing it in the Macros Dialog. Use the keys ALT+F8 to display it.
Please Login or Register to view this content.
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!)
Thanks for the quick reply, Leith. I'll check this out over the next day or so and get back to you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks