Has anybody already tried mailing from Excel?
I have an Excel spreadsheet with a button inside. This button activates a macro that sends the active sheet attachment via Outlook. The problem is that Excel, via function xlDialogSendMail, calls Outlook. Then asks me to click send and I send the mail without opening Outlook.
Do any one have experience in this field?
My code for the button:
I get a warning in this code.
Private Sub CommandButton1_Click()
Dim Destination As String
Dim Source As String
Destination = "email@example.com"
Source = "Source mail"
ActiveWorkbook.SendMail Destination, Source, False