Hello Excel masters,
I have run into an issue while automating tasks at the work place. If there is one thing this forum has taught me (but there is a lot) it is that nothing is impossible to accomplish with Excel and VBA.
I have a workbook containing schedules and a separate summary worksheet for each employee. Each worksheet has a command button triggering a macro to E-Mail the worksheet to that employee. The code is working with no problems using mailenvelope, however, the resulting E-mail message does not include the users signature from outlook. I have tried the .display and the .send option of mailenvelope, but the result is the same.
Each workstation has multiple users that can be logged in and each outlook is configured to the user, including signatures. Is this a bug in the Office suite program, or is there something I'm missing? Is there another approach I should be taking in VBA to send the worksheet (or range on a worksheet) to E-Mail via Outlook as the message body?
Thank you all for your collective assistance. I appreciate all of the assistance and guidance you provide.
Scott
Bookmarks