Recent content by Nravota

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

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

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

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

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

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!

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

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

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

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

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

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