Search results for query: *

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

Well, I don't know, I was just trying to help explain what he means but he isn't even replying now so can't really do much more... Thanks, Rebecca

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

As normal, Dim objActiveWkb.Worksheets as Object Thanks, Rebecca

One more important detail I forgot! Set objActiveWrksheet = objActiveWkb.Worksheets("Sheet1") 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 "'" &...

I believe CoreyVI wants to effectively put them in order and then give the top 5 (with the highest ratings) ranks from 1-5... Thanks, Rebecca

So let me just make sure I understand, where do you want the rank of that customer to be kept? Is there a rank field? Thanks, Rebecca

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

right click* Thanks, Rebecca