Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to send file to email
All
I have file contining macros that I need to send via email (then enter relevant recipient - this changes all the time). The file works fine on my pc but when I send to colleagues to test, the macros within the file work fine, but the 'send file as attachment to email' component won't work on the pC any thoughts this is the code I am using (from a recorded macro) Sub HeadofSchool() ' ' HeadofSchool Macro ' ' ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True ActiveSheet.EnableSelection = xlNoSelection Sheets("Delegate").Select Application.Dialogs(xlDialogSendMail).Show End Sub any assistance appreciated Shaz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you send an excel file as a link in an email in excel 2007 | Excel Discussion (Misc queries) | |||
send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
Send Email | Excel Discussion (Misc queries) | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |