VBA Macro to attach the same three files

  • Thread starter Thread starter Go
  • Start date Start date
G

Go

Hi there,

I've worked with VBA in Excel and Access but not sure how it works in
Outlook 2007.

I'd like to create a button on an email message that will allow me to
quickly attach the same three documents that I attach all the time.

I'm not sure what the code would be and also if I can add buttons to a mail
message to run them.

Could anyone guide me. Any help/guidance would be very much appreciated



Thanks

G
 
See this example, you can right click the toolbar of an opened e-mail, and
customize it, that is drag the macro name on to the toolbar.

Public Sub AddFiles()
Dim Mail as outlook.MailItem
Set Mail=Application.ActiveInspector.CurrentItem
Mail.Attachments.Add "c:\file.txt"
End Sub

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Wed, 11 Feb 2009 20:51:00 -0800 schrieb Go:
 
Back
Top