A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Attaching attachments



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 9th 07, 11:59 AM posted to microsoft.public.outlook.program_vba
Youie
external usenet poster
 
Posts: 2
Default 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

Ads
  #2  
Old September 10th 07, 06:41 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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

  #3  
Old September 11th 07, 09:59 AM posted to microsoft.public.outlook.program_vba
Youie
external usenet poster
 
Posts: 2
Default 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....

  #4  
Old September 12th 07, 05:56 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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....

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Attaching folders in OE shoil Outlook Express 8 September 7th 07 05:20 PM
Attaching Shortcuts to AppointmentItems dch3 Outlook and VBA 1 November 13th 06 06:20 AM
Attaching .exe files TChamp3121 Outlook - General Queries 3 October 13th 06 05:48 AM
Attaching Document Links markinkent2 Outlook - Installation 1 July 10th 06 05:12 PM
help attaching files Uncle Vinnie Outlook - General Queries 3 April 24th 06 03:20 PM


All times are GMT +1. The time now is 11:46 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-2025 Outlook Banter.
The comments are property of their posters.