Hi Diane,
I tried this but it did not open the excel document "Email Register" and save the information. this is the code i tried.
Option Explicit
Public Sub SaveMessageAsMsg()
Dim oMail As Outlook.MailItem
Dim sPath As String
Dim dtDate As Date
Dim sName As String
Dim enviro As...
Hi all, I have a macro at the minute which i have found and changed to suit my needs which saves an email in a file location on my server at work. I have just found another macro which inputs details from an email message into an excel spreadsheet. i was wondering if anyone would be able to help...
I have an 2 issue's with the following code, which i was hoping someone could help me with....
1. The code only allows me to input the full folder name to save the email on my server, i would like it to use just the number element. This is a general folder name: "13469 - ABB - Project Grange...
thanks for your help, i'm very new to VBA so having difficulties with the code. can you point me in the right direction of a thread where it might have already been completed.
I have seen a thread this morning "Save Emails on Hard Drive" which interested me I was wondering if this code can be changed at all to complete the following?
1. When the macro is run a input box appears for a string of text to input the location of the folder on a server. IE Project Number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.