jamesmarcos75
New Member
- Joined
- Sep 23, 2006
- Messages
- 2
I have set up button in excel that automatically attaches the file to an e-mail and fills out the TO: and SUBJECT: fields. The code is as follows:
Private Sub ClickHereCore_Click()
Application.Dialogs(xlDialogSendMail).Show _
arg1:=Array("name@yahoo.com", "name2@yahoo.com"), _
arg2:="Subject Text"
End Sub
Does anyone no how to amend this code to have the code pull certain text in Cell A1 of the Sheet 1 into the subject field?
Thanks in advance!
Jim
Private Sub ClickHereCore_Click()
Application.Dialogs(xlDialogSendMail).Show _
arg1:=Array("name@yahoo.com", "name2@yahoo.com"), _
arg2:="Subject Text"
End Sub
Does anyone no how to amend this code to have the code pull certain text in Cell A1 of the Sheet 1 into the subject field?
Thanks in advance!
Jim