VBA to send Email (outlook) with title of workbook

  • Good day-


    I have searched, and I admit, I may not be using correct keywords, but looking for the correct line of code that when button is clicked it will take the name of the workbook file I am using and in the SUBJECT line of the email show " thefilename.xxx is now prepared for review". I have tried a few ideas, but nothing seems to work.


    I am enclosing the code I am using as I have seen a multitude of codings of how to send the email. BTW--- sending the email works perfectly upon button click. Just hoping to add the file name to subject.



    thanks in advanc e

  • Re: VBA to send Email (outlook) with title of workbook


    .

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!