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

Opening & Sending a previously saved mail item



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 5th 06, 12:34 PM posted to microsoft.public.outlook.program_vba
WhytheQ
external usenet poster
 
Posts: 21
Default Opening & Sending a previously saved mail item

Here's a tricky one!

I've got an e-mail that is set up and saved in a network folder e.g
J:\Finance\MYMAIL.??? (as you can see I'm not even sure what the file
stem is for an outlook mailitem!)
I don't know how to get a hold of htis object....usually in code I find
myself creating a new mail item, that is using the following code:

Set MyOutMail = OutApp.CreateItem(0)

....but if the mail already exists I'm not too sure how to reference it.
Once I've got hold of the object I intend on changing some of the
properties and then sending it which should be easy enough.

Any help greatly appreciated,
Regards,
Jason.

  #2  
Old May 5th 06, 12:40 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Opening & Sending a previously saved mail item

If it's an .oft or .msg file (and why don't you know???), you can use the Application.CreateItemFromTemplate command to create a new unsent item that's a copy of the saved file.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"WhytheQ" wrote in message oups.com...
Here's a tricky one!

I've got an e-mail that is set up and saved in a network folder e.g
J:\Finance\MYMAIL.??? (as you can see I'm not even sure what the file
stem is for an outlook mailitem!)
I don't know how to get a hold of htis object....usually in code I find
myself creating a new mail item, that is using the following code:

Set MyOutMail = OutApp.CreateItem(0)

...but if the mail already exists I'm not too sure how to reference it.
Once I've got hold of the object I intend on changing some of the
properties and then sending it which should be easy enough.

Any help greatly appreciated,
Regards,
Jason.

  #3  
Old May 5th 06, 05:25 PM posted to microsoft.public.outlook.program_vba
WhytheQ
external usenet poster
 
Posts: 21
Default Opening & Sending a previously saved mail item

sue,

thanks for quick response: I'll try it out
out of interest: what is a quick way of finding out a file extension
(I'm pretty sure it's an msg file)

thanks
Jason

  #4  
Old May 6th 06, 03:07 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Opening & Sending a previously saved mail item

Look in the folder? Look at the item properties? Turn on file extensions in Windows Explorer? Pick one or more.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"WhytheQ" wrote in message oups.com...
sue,

thanks for quick response: I'll try it out
out of interest: what is a quick way of finding out a file extension
(I'm pretty sure it's an msg file)

thanks
Jason

  #5  
Old May 9th 06, 11:27 AM posted to microsoft.public.outlook.program_vba
WhytheQ
external usenet poster
 
Posts: 21
Default Opening & Sending a previously saved mail item

Thanks Sue
Just got round to using the createfromitemtemplate - whatan excellent
little method it is!
Adjusted the properties in my explorer aswell (- thanks)

Regards
Jason

 




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
Custom Form saved as *.oft file not opening correctly in Outlook 2003 [email protected] Outlook - Using Forms 3 April 26th 06 02:50 PM
"this item could not be saved because it has been changed" error m Ed Gogol Outlook - Using Contacts 5 April 17th 06 12:27 PM
Sending custom form item as mail attachment to person outside org DougMunday Outlook - Using Forms 4 April 13th 06 08:02 PM
Where does calendar detail go when saved as e-mail item? JV (Sydney) Outlook - Calandaring 0 March 15th 06 03:08 AM
Custom Form saved as *.msg file not opening correctly in Outlook 2 Jim S. Outlook - Using Forms 5 March 6th 06 04:35 PM


All times are GMT +1. The time now is 05:22 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.