Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Attaching attachments (http://www.outlookbanter.com/outlook-vba/56463-attaching-attachments.html)

Youie September 9th 07 11:59 AM

Attaching attachments
 
Hi there,

I need a small piece of code that will help me attach items to the
currently existing open email. I'd like to take an email I've created
and have still open (and not sent) and to be able to click on a macro
button and get it to attach two files of my choosing. I'm able to
create the code to attach but for the life of me, I can't get it to
recognise my open email....can anyone help?

regards, Youie


Michael Bauer [MVP - Outlook] September 10th 07 06:41 AM

Attaching attachments
 


Why don't you use the existing button to attach files?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sun, 09 Sep 2007 03:59:27 -0700 schrieb Youie:

Hi there,

I need a small piece of code that will help me attach items to the
currently existing open email. I'd like to take an email I've created
and have still open (and not sent) and to be able to click on a macro
button and get it to attach two files of my choosing. I'm able to
create the code to attach but for the life of me, I can't get it to
recognise my open email....can anyone help?

regards, Youie


Youie September 11th 07 09:59 AM

Attaching attachments
 
On Sep 10, 5:41 pm, "Michael Bauer [MVP - Outlook]"
wrote:
Why don't you use the existing button to attach files?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sun, 09 Sep 2007 03:59:27 -0700 schrieb Youie:



Hi there,


I need a small piece of code that will help me attach items to the
currently existing open email. I'd like to take an email I've created
and have still open (and not sent) and to be able to click on a macro
button and get it to attach two files of my choosing. I'm able to
create the code to attach but for the life of me, I can't get it to
recognise my open email....can anyone help?


regards, Youie- Hide quoted text -


- Show quoted text -


Hi, I've got 58 merged emails sitting in my outbox in draft mode and
they each require 2 files to be attached to them. They're invites to a
special event and being able to click once and hit send would make it
easier....


Michael Bauer [MVP - Outlook] September 12th 07 05:56 AM

Attaching attachments
 

You can access the opened e-mail with
Application.ActiveInspector.CurrentItem. Or instead one in a folder selected
e-mail with Application.ActiveExplorer.Selection(1)

Both properties return an object that has an Attachments collection. Call
that collection's Add method with the file's path to add the file.
Eventually call the item's Save method.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6


Am Tue, 11 Sep 2007 01:59:50 -0700 schrieb Youie:

On Sep 10, 5:41 pm, "Michael Bauer [MVP - Outlook]"
wrote:
Why don't you use the existing button to attach files?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:

http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sun, 09 Sep 2007 03:59:27 -0700 schrieb Youie:



Hi there,


I need a small piece of code that will help me attach items to the
currently existing open email. I'd like to take an email I've created
and have still open (and not sent) and to be able to click on a macro
button and get it to attach two files of my choosing. I'm able to
create the code to attach but for the life of me, I can't get it to
recognise my open email....can anyone help?


regards, Youie- Hide quoted text -


- Show quoted text -


Hi, I've got 58 merged emails sitting in my outbox in draft mode and
they each require 2 files to be attached to them. They're invites to a
special event and being able to click once and hit send would make it
easier....



All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com