[SOLVED] Send out one Excel worksheet from the workbook

[jackson_hollon]

Hello,

I have a email/Excel question:

I have an Excel workbook content 25 commission worksheets for 25 employees. Every month I have to prepare the commission report and send it to my boss for approval. After that I have to separate the workbook to 25 workbook and send out the final commission report to each employee before cutting them a check. Is there a way i can just send out one worksheet from the workbook to the employee so that I do not have to separate the workbook into 25 report?

Thanks for the help.

Jackson

[TMS]

With a list of employee names, sheet references and email addresses, you could automate the whole process using VBA.

[jackson_hollon]

TMS,

Thanks for the reply. Do you know if there is a ready used VBA codes out there that I can use? I searched the website and I can not find that.

Thanks for the help.

Jackson

[TMS]

http://www.rondebruin.nl/win/s1/outlook/bmail5.htm

http://www.rondebruin.nl/win/s1/outlook/amail2.htm

[jackson_hollon]

TMS,

Thanks for the help.

Jackson

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[TMS]

You're welcome. Thanks for the rep.


Glad you were able to adapt the examples. Always best if you can do it yourself