macros to save then email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have not got a clue about macros so any help will be greatly appreciated.

I need to create a macro that is attached to a button so that when this
button is pressed it saves the sreadsheet (the file name needs to relate to
the reference cell in the spread sheet) then this spreadsheet is attached to
an email so that it can be sent to whoever it needs to be sent to, you urgent
assistance on this will be greatly appreciated.

many thanks
 
maybe this will give you some idea. Assuming the filename you want to save as
is in A1 of the sheet where the button is.

Sub Button1_Click()
ThisWorkbook.SaveAs ActiveSheet.Range("A1").Text
Application.Dialogs(xlDialogSendMail).Show
Arg1:="(e-mail address removed)", Arg2:="Email Subject"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Macro to Convert Value to Number, Sort, then Delete 16
VBA API for Outlook and Email managment 2
SAVE AS/ GET SAVE AS/ 1
Prompt the start of an email...user fills in email address 2
including macro in protected worksheet 2
Email Macro 1

Back
Top