E-mailing workbook using a macro

Posted by Jonathan on February 05, 2001 6:42 PM

I am trying to set up a macro to automatically send the sheet to a mail recipient. Can someone help me with the code? This is what I have so far Application.Dialogs(xlDialogSendMail).Show([FName.LName@companyname.com], [Important Document])
But it keeps telling me "Expected:="

Posted by Dave Hawley on February 06, 2001 12:18 AM

Hi Jonathan

Try:
Sub TryThis
Application.Dialogs(xlDialogSendMail).Show "FName.LName@companyname.com", "Important Document", True
'xlDialogSendMail recipients, subject, return_receipt
End Sub

OzGrid Business Applications

Posted by Michael on February 06, 2001 6:25 AM

Hi Jonathan Sub TryThis Application.Dialogs(xlDialogSendMail).Show "FName.LName@companyname.com", "Important Document", True 'xlDialogSendMail recipients, subject, return_receipt End Sub

One additional question -- How do you send it to more than one person, so it will show everyone that received it?

Best regards,

Michael

Posted by Johnboy on February 06, 2001 11:33 AM

Jonathan

Try:
ActiveWorkbook.SendMail Recipients:="Email@Address", Subject:="Fuel Letter ", ReturnReceipt:=True

Johnboy