Email workbook to specific person and cc others

Try following code.

Please Login or Register  to view this content.

Also make Folder named "Temp" in your D drive before running the code.

Thanks,
Tejas

Thank you very much! Your help is highly appreciated. Am i correct in assuming that the .sendmail command as in the original coding will work with any default mail client as specified in windows whereas your coding is outlook specific. I ask this because i will have to incorporate a command taking into account that the users will have different email clients. If .sendmail does not allow for a cc function, then i will have to give the user an option to send with outlook or other email client.
Thank you!

Yes the problem with SendMail is it doesn't allow CC field as far as I know.
That's why I have taken object of Outlook in my code and so it won't work with other email clients.

But there might be code for other email clients too and you can write code specific to that particular email client.

Thanks, with regards to offering the user the choice between outlook and other email client, will a InputBox and IF statements be the best solution? May i pm you with another question or 2, please?

Thanks!

Instead of InputBox, I will suggest you to create a UserForm. In that you will get option of Dropdown list too.

Yes you can PM me!

@ CaptMcK

Welcome to the forum.

Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

Also, please keep your questions in the forum as opposed to PM's so that others can learn from them. There is, in fact, a rule against it:

Rule 4 of our Forum [/I]RULES. Don't Private Message, Visitor message or email questions to moderators or other members. All questions and answers will benefit other posters like yourself. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Hi, my appologies... will do so in future. tx!

How do i get the message to open in outlook with all the info and attachment but ready to be sent manually?
tx

Sorry I didn't get what you are trying to convey.

Can you please clarify in detail?

Sorry! in the outlook code you provided: How do adjust for creating and new message, adding the TO and CC information, attaching the workbook and then finally opening the message (as the .sendmail command does) to be sent manually. The code you provided does all this automatically but i'd like to adjust it so that the message window pops up and i can choose from which account to send it from or add a message, etc......tx!

Just replace .Send by .Display

Will try that! Thanks a lot

Hi Tejas, thanks for your help on this, i've created a form which is opened by clicking the email button and modified the code as follows:

Please Login or Register  to view this content.

Hi,

Thats great. Your additions to the code are just perfect!

Please don't forget to mark the thread as Solved and Add to my reputations if you find it proper.

Thanks,
Tejas

Awesome! Thanks for all your assistance!