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