Recent content by nathandavies

  1. nathandavies

    Email Details to Excel & Save as .MSG on one macro - combination of 2 macros

    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...
  2. nathandavies

    Email Details to Excel & Save as .MSG on one macro - combination of 2 macros

    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...
  3. nathandavies

    Creating a Select Case for a directory of folders

    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...
  4. nathandavies

    How to save emails to a specific folder on a network automatically using a macro

    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.
  5. nathandavies

    How to save emails to a specific folder on a network automatically using a macro

    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...
Top