Sorry but im a novice on excel
Im looking to add a button on a spreadsheet that when its pressed emails the documment in full to two email addresses
i know this is possible but have no idea on how to create
Can anyone please help
Im happy to send document to be reviewed etc
Last edited by fragle2112; 07-29-2016 at 10:48 AM.
Sub send_wb()
adr1=[a1] 'emails
attach$ = ThisWorkbook.FullName ' attach wb
res = SendEmailUsingOutlook(adr1, "body", "ref", attach$)
If res Then Debug.Print "send" Else Debug.Print "error"
End Sub
thank you Tim
I tried adding to the sheet but this is not working
Can anyone please help
Last edited by fragle2112; 08-08-2016 at 03:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks