This is an excellent Tip that you passed on to your readers. I have been
using this strategy and it works well.
My question, any way to place text in the body of the email, in addition to
the subject text?
USE VBA TO E-MAIL YOUR WORKBOOKIt’s very easy to send a workbook using Excel VBA code. The workbook is
sent using your default mail program. Simply use the SendMail method as
shown in the sample procedure below.
Sub SendTheWorkbook()
ActiveWorkbook.SendMail _
Recipients:=”you@youraddress.com”, _
Subject:=”Here is the workbook–“, _
ReturnReceipt:=False
End Sub
Thanks,
Rick
