Hello everybody!
Won't somebody help me to make a macro for attaching a file dialog in a new letter in Outlook 2007, for I can asign a shortcut for it.
I know how to create, save and add a shortcut to macro, but almost nothing in VBA programming.
I found a piece of code:
Sub Attach_MyFile()
Set NewItem = Application.ActiveInspector.CurrentItem
NewItem.Attachments.Add “\\path\filename”
End Sub
but it's not what I need, because it takes file from a specified place and doesn't give a dialog to select.
I would be grateful for help, and I think it will be very useful for thousands of people all over the Earth who are compelled to work with Outlook.
I like Thunderbird very much, and I made shortcuts myself there, but because of the corporative rules in my company I can use only Outlook 2007.
Thank you
Won't somebody help me to make a macro for attaching a file dialog in a new letter in Outlook 2007, for I can asign a shortcut for it.
I know how to create, save and add a shortcut to macro, but almost nothing in VBA programming.
I found a piece of code:
Sub Attach_MyFile()
Set NewItem = Application.ActiveInspector.CurrentItem
NewItem.Attachments.Add “\\path\filename”
End Sub
but it's not what I need, because it takes file from a specified place and doesn't give a dialog to select.
I would be grateful for help, and I think it will be very useful for thousands of people all over the Earth who are compelled to work with Outlook.
I like Thunderbird very much, and I made shortcuts myself there, but because of the corporative rules in my company I can use only Outlook 2007.
Thank you