biko1990
01-29-2019, 03:39 AM
Hi Guys,
I'm new on this forum, i already tried some searching to try if someone asked the same question but didn't succeeded.
I found a macro on the internet which i want to use, the macro pops up a fence, each time i sent an email, in which i can select the folder in which i want to store the email.
on the following location i found the macro:
https://www.datanumen.com/blogs/auto-save-specific-sent-emails-non-default-folder-outlook-vba/
the macro is the following:
Dim desFolder As Folder
If TypeName(Item) = "MailItem" And Item.DeleteAfterSubmit = False Then
'specify the email
If InStr(Item.To, "shirley") > 0 Or InStr(LCase(Item.Subject), "test") > 0 Then
'Display the “Select Folder” dialog box
Set desFolder = Application.Session.PickFolder
Set Item.SaveSentMessageFolder = desFolder
End If
End If
End Sub
Now the problem is the following:
When I write the macro into VBA in Outlook, the macro does not appear in the run/sub user form (F5).
Probably just a small mistake? Is there anyone who knows how to tackle this issue?
Thanks in advance!
Biko
I'm new on this forum, i already tried some searching to try if someone asked the same question but didn't succeeded.
I found a macro on the internet which i want to use, the macro pops up a fence, each time i sent an email, in which i can select the folder in which i want to store the email.
on the following location i found the macro:
https://www.datanumen.com/blogs/auto-save-specific-sent-emails-non-default-folder-outlook-vba/
the macro is the following:
Dim desFolder As Folder
If TypeName(Item) = "MailItem" And Item.DeleteAfterSubmit = False Then
'specify the email
If InStr(Item.To, "shirley") > 0 Or InStr(LCase(Item.Subject), "test") > 0 Then
'Display the “Select Folder” dialog box
Set desFolder = Application.Session.PickFolder
Set Item.SaveSentMessageFolder = desFolder
End If
End If
End Sub
Now the problem is the following:
When I write the macro into VBA in Outlook, the macro does not appear in the run/sub user form (F5).
Probably just a small mistake? Is there anyone who knows how to tackle this issue?
Thanks in advance!
Biko