Recent content by Nravota

  1. N

    Paste content to Excel when .txt file (attachment) is opened

    Hi Guys, I have a lot of emails with txt attachments that I need to handle every day. I select the message, open the attachement in notepad (without saving) and then manually paste it to excel workbook. I want to be able when I open the attachment that it is automatically loaded in this excel...
  2. N

    Get the seconds with userproperties.add method VBA Outlook

    I also tried objProperty.Value = vbLongTime But it gives: 02/01/1900 00:00 :(. Is there a way to show current time with seconds?
  3. N

    Get the seconds with userproperties.add method VBA Outlook

    Hi Diane, I do not need two fields, I just looked for another way to solve this but it works only with non-user-defined columns such as received. I am not sure what you mean by value, for the field created invba outlook I use the =now() formula only. I do not know how to properly format it...
  4. N

    Get the seconds with userproperties.add method VBA Outlook

    Hi Everyone and thanks in advance for your help, I am trying to create a user-defined custom field with the userproperties.add method in vba outlook. The idea is that when the user clicks on a macro button the field will show the current time with seconds included. I made the user-defined...
  5. N

    VBA Outlook reference to Excel and assigning category

    I am sorry, the correct one is : .Categories ="Test"
  6. N

    VBA Outlook reference to Excel and assigning category

    Thanks, Michael! The code works beautifully now. I also found the solution how to assign the category. I only had to change it to: .Category = "Test" Once again thanks for your invaluable help and cheers!
  7. N

    VBA Outlook reference to Excel and assigning category

    Ok, great! This works now when the data in C6 is saved. However, in my case the file is currently opened so if I open the file once again, I will lose the non-saved info and will not get the reference. Treshold_file is xlsm file which is currently opened and I want the macro to get to cell C6...
  8. N

    VBA Outlook reference to Excel and assigning category

    The object required error is here.. Set sheet4 = treshold_file.Object.Sheets(4)
  9. N

    VBA Outlook reference to Excel and assigning category

    Yes, I removed these two lines from the code: Dim obj As New DataObject obj.SetText txt When I run the code without these two lines I get: "runtime error 424: object required." I do not want to copy anyhting to clipboard, this is not my intention, I simply want the name in the excel file...
  10. N

    VBA Outlook reference to Excel and assigning category

    Dim obj As New DataObject Here I get compile error: "user-defined type not defined."... when I remove the "obj", I get runtime error 424: object required..
  11. N

    VBA Outlook reference to Excel and assigning category

    I am sorry, I did not know how to paste it properly. Here it is Sub Attach_your_last_saved_file() 'set a reference to the scripting object Dim fso As Scripting.FileSystemObject Dim strFile As String Dim fsoFile As Scripting.File Dim fsoFldr As Scripting.Folder Dim dtNew As Date, sNew As...
  12. N

    VBA Outlook reference to Excel and assigning category

    Hi Guys and thanks in advance for any info shared. I am trying to automate outlook so it can reply to a selected mail and attach the last saved excel file. I did that with the great help from Diane Poremsku for which I am very greatful, but now I am stuck with two things: 1. I want to add a...
Top