VBA, Excel -> Send To -> Mail Recipient problem

Excel -> Send To -> Mail Recipient problem

Author	Message
Matthew Fitzmauric #1 / 4	Excel -> Send To -> Mail Recipient problem Hi all, I'd like to customise Excel's Send Active Sheet To Mail Recipient functionality. I'm trying to create a macro/Addin that can add an attachment to the mail. When i record the action, no code is generated and when i try to customise the Toolbar i am unable to. Any ideas? -- Matthew Fitzmaurice Manager, Portal Development (MCSD) MacroView Business Technology Pty Limited "Office and beyond"
Fri, 02 Dec 2005 09:41:03 GMT

Stephen Simon #2 / 4	Excel -> Send To -> Mail Recipient problem Hi Matthew This isn't what you were after, but you can email a worksheet from an XLO macro, picking up the recipient email address and the subject line from cell references. Try this: Sub Email() ActiveWorkbook.SendMail Recipients:=Range("A1"), Subject:=Range("F1") End Sub Of course place the recipient's email address in A! and the subject text in F1 (or change the cell refs if necessary. hth Steve Quote: >Hi all, >I'd like to customise Excel's Send Active Sheet To Mail Recipient >functionality. >I'm trying to create a macro/Addin that can add an attachment to the mail. >When i record the action, no code is generated and when i try to customise >the Toolbar i am unable to. >Any ideas? remove "_ILY_" to email me
Fri, 02 Dec 2005 23:40:45 GMT

howar #3 / 4	Excel -> Send To -> Mail Recipient problem Matthew, I'm having the same problem as well. I tried using MyMail.Attachments.Add <file path>, OlAttachmentType.olEmbeddeditem etc., but doesn't seem to work. I know you cannot do this in Outlook 97: http://support.microsoft.com/default.aspx? scid=http://support.microsoft.com:80/support/kb/articles/q1 72/7/18.asp&NoWebContent=1 But i'm not sure about Outlook 2000. Have you found anything yet? I posted this question on a couple other sites, and nobody seemed to have an solution. thanks, howard Quote: >-----Original Message----- >Hi all, >I'd like to customise Excel's Send Active Sheet To Mail Recipient >functionality. >I'm trying to create a macro/Addin that can add an attachment to the mail. Quote: >When i record the action, no code is generated and when i try to customise >the Toolbar i am unable to. >Any ideas? >-- >Matthew Fitzmaurice >Manager, Portal Development (MCSD) >MacroView Business Technology Pty Limited >"Office and beyond" >Phone (612) 9279 4000 Fax (612) 9279 4111 email Quote: >.
Sat, 03 Dec 2005 22:04:25 GMT

Matthew Fitzmauric #4 / 4	Excel -> Send To -> Mail Recipient problem In the end i copied the current steet into a new workbook, temporarily saved it and attached it to a new mail. Not what i wanted, but it works... -- Matthew Fitzmaurice Manager, Portal Development (MCSD) MacroView Business Technology Pty Limited "Office and beyond" Quote: > Matthew, > I'm having the same problem as well. I tried using > MyMail.Attachments.Add <file path>, > OlAttachmentType.olEmbeddeditem > etc., but doesn't seem to work. I know you cannot do this > in Outlook 97: > http://support.microsoft.com/default.aspx? > scid=http://support.microsoft.com:80/support/kb/articles/q1 > 72/7/18.asp&NoWebContent=1 > But i'm not sure about Outlook 2000. Have you found > anything yet? I posted this question on a couple other > sites, and nobody seemed to have an solution. > thanks, > howard > >-----Original Message----- > >Hi all, > >I'd like to customise Excel's Send Active Sheet To Mail > Recipient > >functionality. > >I'm trying to create a macro/Addin that can add an > attachment to the mail. > >When i record the action, no code is generated and when i > try to customise > >the Toolbar i am unable to. > >Any ideas? > >-- > >Matthew Fitzmaurice > >Manager, Portal Development (MCSD) > >MacroView Business Technology Pty Limited > >"Office and beyond" > >Phone (612) 9279 4000 Fax (612) 9279 4111 email > >.
Sun, 11 Dec 2005 08:56:15 GMT

Page 1 of 1

[ 4 post ]