Oh, and I guess you can end the second for loop (with the j's) once you have found the specific attachment; efficiency :D
If objAtt.fileName = chobjAtt Then
objAtt.SaveAsFile file
Exit Sub
End If
It may be problematic when you have several Excel files with...
Okay, I tried to create such an array. I initially tried to store the attachments themselves within the array, and then just I would just have had to write 'a(2).SaveAsFile file', but that did not work. Hence I had to create some workaround:
1) Move through all attachments and store the file...
It's not always that easy to grab a specific attachment.
Example: the MailItem does have 3 Excel files attached and one screenshot embedded. Now you have 4 attachments in total. And if Outlook does not get the order right, it may be that the screenshot is exactly the attachment #3. Sometimes...
Is it necessary to have the Word Documents always in the same folder? Or is it possible to create some kind of temporary folder? Are these documents already ordered the way you want to send them?
50,000 documents is quite a big number, so I would do it the following:
Create a folder called...
So, now I tested the macro on another folder that I copied and I worked like a charm. 3,600 messages and only 2 error lines in the log, both of which I expected (file name too Long).
So I come to the conclusion that there must indeed be a conflict with the digital signatures of the messages...
Okay, but that's what Diane already suggested. You will need to specify the number. Also, it may be a tad little bit more complicated than you imagined, but let's try:
The (untested) code that I provide should loop through all the attachments of the MailItem and save the first Excel file it...
Hey, I am working on a similar project and I also encountered your problem.
I solved it the following way:
1) select the parent folder
2) do all the stuff you want for the parent folder
3) loop recursively through the subfolders and do all the stuff for your subfolders
' In your main sub...
Hey Folks,
I am trying to write a macro that loops through an Outlook folder and its subfolders, looks for messages with attachments, saves them somewhere else (e.g. D:\...), and, if there has not been any error, deletes the specific attachment and writes down a log (I use that with in...
So I wonder whether I should proceed like the following:
Run the macro in Outlook, insert the vacation into the Excel sheet calendar, filter the sheet for the people who got vacation on a certain date, write a string like "Vacation Team Today: Member A Alias, Member B Alias, Member C Alias...
Hey,
thank you for your response! Obvious question: is there any way to solve the problem with the possibility of "fake appointments", though? And probably without having to start at beginning again?
Okay, let's try to type it in a shorter version:
Question as in the header.
I wrote a macro that uses the shared folder option for the Outlook calendar.
Appointments into other users' calendars still can only be placed via a macro (the authorisation (calendar permission) options are quite...
No one willing to answer?
Is the question understandable? Or is there another thread already which contains the answer? I tried to search within the forum, but with no success so far. Maybe you could redirect me to the certain thread.
Hello to everyone,
I hope that someone can help me with my question. But let me describe the situation a bit better first.
I created an Outlook macro that does the following:
- I click on a button, an Outlook UserForm pops up, which has 2 text fields and 2 command buttons.
- I insert two...
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.