![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Using outlook 2003 I am trying to get outlook to close the currently opened
email after it saves it. I have got everything working but the closeing part. Can someone give me some ideas, suggestions or the write code to get this to work. Here is what I have at this point: Sub SaveAsOF() '## Saves current email to users My Documents and Emails folder Dim myItem As Outlook.Inspector Dim objItem As Object Set myItem = Application.ActiveInspector If Not TypeName(myItem) = "Nothing" Then Set objItem = myItem.CurrentItem strname = objItem.Subject strInvalidSequences = "`+ +~+!+@+$+%+^+&+*+=+{+}+[+]+|+\+""+:+;+++/" strArrInvalidSequence = Split(strInvalidSequences, "+") For x = 0 To UBound(strArrInvalidSequence) Text = strArrInvalidSequence(x) strname = Replace(strname, Text, "_") Next x strpath = Environ("HOMEdrive") & "My Documents\Emails\" & strname & ".msg" 'Prompt the user for confirmation Dim strPrompt As String strPrompt = "The email has been saved as " & strpath CheckFolder objItem.SaveAs Environ("HOMEdrive") & "\My Documents\Emails\" & strname & ".msg", olMSG MsgBox (strPrompt) Else MsgBox "You must open the email to save it, please double click the email and try again." End If End Sub Sub CheckFolder() Dim fso Dim fol As String fol = Environ("HOMEdrive") & "My Documents\Emails" Set fso = CreateObject("Scripting.FileSystemObject") If Not fso.FolderExists(fol) Then fso.CreateFolder (fol) End If End Sub Since some people do not have the "Emails" folder the second macro included here adds it. Thanks in advance for any help on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to close active-form and open a new one | Boein | Outlook - Using Forms | 4 | May 27th 08 02:05 PM |
Automatic Maintenance from each 100 open/close to 200? | Alex Tolle [Alcahest] | Outlook Express | 1 | March 6th 07 03:22 AM |
how do I close outlook 2003 to retain the calendars that are open | mmstokes4477 | Outlook - Calandaring | 3 | February 28th 07 08:31 PM |
Macro button that saves the email I'm reading to c:\outlook as .ms | kvpb2000 | Outlook and VBA | 6 | November 2nd 06 09:47 AM |
Which event is triggered when user saves email item? | Kasper | Add-ins for Outlook | 4 | September 22nd 06 02:26 PM |