Forum Discussion

Hannah Lively's avatar
Hannah Lively
Copper Contributor
Mar 08, 2018

Macro to attach workbook to email

Good Morning,

 

I am looking for assistant in using a form control button (which I already have in place) to send a worksheet to a certain email address.  The worksheet is a form that individuals will fill out and to ensure that it goes to the proper location, I want the correct email address to load when the the new email message window opens.  

 

I recorded the macro and here is the code:

Sub SendEmail()
'
' SendEmail Macro
' Send TA for to ta@apwu.org.
'

'
ActiveWindow.SmallScroll Down:=0
Application.Dialogs(xlDialogSendMail).Show

End Sub

 

It works great except I need to add that the "To" section of the email should read "form@xyz.com".  I want the email message to display and not send automatically as the individuals will need to fill in the subject line and anything they want in the body of the email.

 

Thank you

No RepliesBe the first to reply