I have a macro that will copy a worksheet and then attach that new workbook to an email through lotus notes. Our company is moving to Google Mail (gmail) and I am trying to find away to continue to do this. Google Mail does not appear in the Internet Properties -> Programs -> Email where I need it the Email Application to appear for the code to work. I have done some searching but am not having no luck so was hoping someone had some ideas, suggestions or knew how to do this. Any thing is appreciated.
Here is the code I currently use.
Here is the code I currently use.
Code:
ChDir "C:\Excel"
ActiveWorkbook.SaveAs FileName:= _
"C:\Excel\" & ThisWorkbook.ActiveSheet.Name & " PERFORMANCE SUMMARY.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.Dialogs(xlDialogSendMail).Show
newvendor.Activate
ActiveWindow.Close
Vendor.Activate