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

save certain emails from inbox to network drive with a macro



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 1st 09, 02:14 PM posted to microsoft.public.outlook.program_vba
Herb Segal
external usenet poster
 
Posts: 2
Default save certain emails from inbox to network drive with a macro

Is there a way to create a macro that, when run, will save an email from my
inbox to a folder on our network? I also thought a macro would not only save
to a network folder but also delete from my inbox. Not every email in my
inbox but only the ones I want to save.

I use drag and drop now but thought the macro might make it a little easier.
When I'm in MS outlook I can't always see my desktop so drag and drop if
difficult. I'm constantly closing or minimizing programs so I can see the
folder I want to drag to.

I gather there is no record function in ms outlook like you find in excel.

Ads
  #2  
Old November 2nd 09, 03:39 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default save certain emails from inbox to network drive with a macro

Outlook has no macro recorder. You write macros in Outlook using VBA code
that you have to write from scratch.

You can select items in a folder, get the Selection collection for that
window (Explorer) and iterate the Selection. For each selected MailItem you
can use the SaveAs() method to save the items and then delete the item using
a count down loop.

You might want to search for code similar to what you want to get you
started at www.outlookcode.com

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Herb Segal" wrote in message
...
Is there a way to create a macro that, when run, will save an email from
my inbox to a folder on our network? I also thought a macro would not only
save to a network folder but also delete from my inbox. Not every email in
my inbox but only the ones I want to save.

I use drag and drop now but thought the macro might make it a little
easier. When I'm in MS outlook I can't always see my desktop so drag and
drop if difficult. I'm constantly closing or minimizing programs so I can
see the folder I want to drag to.

I gather there is no record function in ms outlook like you find in excel.


  #3  
Old November 2nd 09, 04:17 PM posted to microsoft.public.outlook.program_vba
Herb Segal[_2_]
external usenet poster
 
Posts: 6
Default save certain emails from inbox to network drive with a macro

Thank you very much.

"Ken Slovak - [MVP - Outlook]" wrote in message
...
Outlook has no macro recorder. You write macros in Outlook using VBA code
that you have to write from scratch.

You can select items in a folder, get the Selection collection for that
window (Explorer) and iterate the Selection. For each selected MailItem
you can use the SaveAs() method to save the items and then delete the item
using a count down loop.

You might want to search for code similar to what you want to get you
started at www.outlookcode.com

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Herb Segal" wrote in message
...
Is there a way to create a macro that, when run, will save an email from
my inbox to a folder on our network? I also thought a macro would not
only save to a network folder but also delete from my inbox. Not every
email in my inbox but only the ones I want to save.

I use drag and drop now but thought the macro might make it a little
easier. When I'm in MS outlook I can't always see my desktop so drag and
drop if difficult. I'm constantly closing or minimizing programs so I can
see the folder I want to drag to.

I gather there is no record function in ms outlook like you find in
excel.




 




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
Newbie- is this possible? (code to save attachments from server to network drive, without opening email locally) ker_01 Outlook and VBA 3 October 3rd 08 03:33 PM
Save to the network \\network\publicfolders\contacts instead of the c:\drive Alex B.[_2_] Outlook - Using Contacts 0 September 14th 07 07:31 PM
Autoarchiving to network drive STapley Outlook - General Queries 3 June 5th 07 03:33 PM
Can I install Outlook on my network drive and if so how? thtpen Outlook - Installation 1 May 6th 07 06:57 PM
Save emails by sender to local drive folder Albert Outlook - General Queries 1 January 12th 06 04:42 PM


All times are GMT +1. The time now is 08:14 PM.


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.