Thanks Prasad , is there a way to temporarily save and delete the file after mail send. I am trying to email a read only user form.
Appreciate your help
I am trying to email active workbook via outlook. These are my codes. The email is displayed. however there is no attachment. Could anyone look at my codes and advise what I am missing?
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set...
Hi
I have a sheet with 400000 rows and like to have macro break it into small tabs each with 65000 rows and copy the header in every tabs. can somebody help me please?