PDA

View Full Version : Solved: Overwrite Send Mail as Attachment



markh1182
05-15-2007, 08:42 AM
Hi, When you go into File, Send To, Mail as Attachment, can you overwrite this with your own vba command? I would like a msgbox to popup before the email opens.

I have tried to use a Sub called FileSendMail but this did not seem to work.

Marcster
05-15-2007, 10:52 AM
.

Marcster
05-15-2007, 10:53 AM
The sub should be:

Sub FileSendMail()
Msgbox "That menu command has been disabled."
End Sub


More on over riding Word commands:
http://www.vbaexpress.com/forum/showthread.php?t=11491&highlight=override

Microsoft:
http://msdn2.microsoft.com/en-us/library/aa140285(office.10).aspx

Marcster.

markh1182
05-16-2007, 01:19 AM
Annoyingly that still wouldn't override the actual command so I have decided to just remove that button and add an exact copy running my own macro instead.

Unless anyone else has any ideas?

Charlize
05-16-2007, 01:46 AM
Where do you place that code ? In thisdocument or normal.dot ... It works fine by me when placed in thisdocument.

Charlize

markh1182
05-16-2007, 02:01 AM
I have tried in both normal and thisdocument but to no avail.

Nevermind, I will just replace that button with my own using my own macro. Our MS Word has been customised here so it may be something around that.

Thanks for your help.