View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan D. Alan D. is offline
external usenet poster
 
Posts: 4
Default setting address in "mail as attachment" macro

I'm trying to write a simple macro that will email a completed Excel-based
form to a designated email address. The macro as it sits so far -

Sub MailFile()
'
' MailFile Macro
'
Application.Dialogs(xlDialogSendMail).Show
End Sub

opens the mail form with the file attached just fine, but does not input the
designated email address. Can someone help me fill in the blank, as it were.
Thanks!

Alan D.