Modifying an Excel 2000 Macro
Thank you Sandy. That helped tremendously. Great tip.
--
LPS
"Sandy" wrote:
Look in the help section of the VBE and look for Built-In Dialog Box
Argument Lists under xlDialogSendMail you will see some arguments to
the right you can use for Subject, Recipient, and return receipt.
Heres an example:
Application.Dialogs(xlDialogSendMail).Show arg1:="Recipients Name",
arg2:="My Subject"
Good luck,
Sandy
LPS wrote:
Using Excel 2000, I have this macro, listed below, which creates a new blank
e-mail message. I would like to modify it so that when the macro executes
and the new e-mail is created an e-mail address automatically is entered in
the To: field.
Sub Send_Form()
'
' Send_Form Macro
' Macro recorded 20/03/2006 by LPS. Used to send form as an E-Mail attachment
'
'
Application.Dialogs(xlDialogSendMail).Show
End Sub
Thank you for any and all help.
--
LPS
|