Thanks for the reply!
I have found a program which will create the ribbon with custom icons however I would prefer to know how it works myself so I could do it without using the program.
So in answer, yes I am still interested in an answer
Thank you!
Thanks,
Rebecca
I already have some code which pulls all emails in my inbox into access then moves the emails into new outlook folders. While doing this, any attachments to the emails are saved in a local attachments folder.
My problem is that if there is an embedded image in the email, that is seen as an...
I have some code which saves emails into a database, creates new folders for new senders etc etc but what I now want to do is when a new email comes in, i want any attachments to be saved into a table (by saving the location and then having the ability to go back in and open it from that...
Hopefully this is the right forum to post this in... if not please point me in the right direction. I figured it was more of an outlook automation issue rather than a vba issue. I have some code which saves emails into a database, creates new folders for new senders etc etc but what I now want...
I think CoreyVI simply included those formulas to show exactly what he wanted to accomplish... And I think it would make sense to define highest to lowest as customers with a rating of 5 would be highest and customers with ratings of 0 would be lowest.
Thanks,
Rebecca
I think I just did... put them from highest to lowest (in order...) and then put 1, 2, 3, 4, 5 against the ones which are the 5 highest...
Thanks,
Rebecca
I'm not too sure what else it could be then... just one thing I can see which you could change but I'm not sure how it could make the application hang but I'll mention it anyway,
I believe you don't need to set your 'RSL' and 'DB' to = Nothing.
Sorry I can't offer you more help perhaps PHV...
objActiveWkb.Close SaveChanges:=True
XL.Application.Quit
You do appear to be closing it but perhaps it will work better with the above code because of the changes?
also you set everything but active workbook to be nothing
Set objActiveWkb = Nothing
Thanks,
Rebecca
I have just had a look, this may help. I declared objActiveWrksheet as an object and (obviously) wherever I had activeworksheet i just replaced it with objActiveWrksheet. Good luck!
Thanks,
Rebecca
I have had this problem before and I can't find the database where it happened but I seem to remember this it is the 'ActiveSheet' which keeps excel hanging... as I can't find it I'm not sure what I replaced it with but I hope this helps anyway!
Thanks,
Rebecca
Hmmm I'm not too sure that this would do what I want it to... I have quite a lot of code so will just post the bit where I want to search for the folder
Set rstClient = db.OpenRecordset("Select foldername from tbl001_clientdetails where hostname = '" & strClientHost & "'")
If "'" &...
Oh I understand now actually - because the rating is also 0-5 I still thought you meant that. Is this data you want to rank in a form or is it just the table?
Thanks,
Rebecca
Why would that not rank them from 0-5 perhaps I'm missing something. You could also use the order by property and order on the rank field...
Thanks,
Rebecca
I have some outlook automation code which is working fine there is just one thing which I can't get to work. Part of my code separates emails depending on the domain name of the sender email address, each has it's own folder. When there is a sender with a new domain name a new folder will be...
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.