Search results

As per title, please can you explain this code? I found it on the internet and "although it does what I want" I do not understand how it works and cannot modify it. code [] Sub HighlightDupes() ' this works if column is filtered and only 'on visible rows Dim i As Long, dic As Variant, v...

Sneuberg, what can I say? Thank you, this just does not seem to do it! What you have done is fantastic. I managed to have a play and it did just what I wanted, thank you very much for taking the time to do this for me. I will incorporate it into the macro for work later this week I hope but...

snueberg, thank you very much. forgive me if I dont try the code for a few days, my head and heart is not in it at the moment. Best friend of over 20 years is going through a cancer scare. smiler44....not smiling at the moment

hi sneuberg. I'm not sure I fully understand. The folder names will be hard coded and so is the wrrd magic. The source folder is = NS.Folders("Personal Folders").Folders("inbox").Folders("testin").Folders("testout") and the destination folder is = NS.Folders("Personal...

soory ScrnChk:- this just makes sure my screen is ready for my macro to send information to the creen and also slows the macro down. there has been a system issue with my macros running to quickly whattodonow:- once the subject line has been chekced for the magic word, I have to decide what...

Lets try again Snueberg, Thank you for the code. I ran it from excel and it made a copy and placed a copy of the email into the other folders. I will see if i can get some of my code below in with your code as there are 2 things 1. I don’t want to copy and move all emails. Only those that have...

insert lots of naughty words. wrote a long reply only for something to time out and i lose the lot smiler44

OP abserlotly appreciates what snueberg has done and what you all do. I just wish I was clever enough to understand it. I will do my best to try your code tomorrow. thank you very much smiler44

sneberg, very kind of you. I will give it a go as soon as I can. Car break down is more pressing for me at the moment, stuffed without a car. I appreciate what you have done and will be back as soon as I can. smiler44

sorry everyone I have not had email notification of your replies. I would like to run the macro using excel thank you for explaining the code I found runs from outlook, I thought it was from excel, doh smiler44

I fond this code on the internet but cant make it work. Do I need to add any references? Set objNS = Application.GetNamespace("MAPI") this gives a runtime error 438 object doesnt support this property or method Sub MoveCopyMessage() Dim objNS As...

sneuberg, that is very kind of you. if you hare happy to have a go i would appreciate it and i too will have a go. your tip of ctrl A is a head start for me. I wont want to select them all just ones that i select. with the code i have and your tip i may be able to get it but i wont turn down...

I dont get the chance to copy a single email, i get the chance to copy the whole folder. smiler44

I have a macro that can move an email from one folder to another. This is fine but i need two other people to get a copy of the email. all 3 people have a folder off of the group email inbox. All emails go to inbox. they get checked and are moved to john or james or paul as required inbox...

this formula opens up an email, fills in the to address and adds a subject line =HYPERLINK("mailto:"&VLOOKUP(A3,'1141 lookup'!AA:AF,5,0)&"?subject="&VLOOKUP(A3,'1141 lookup'!AA:AH,7,0),VLOOKUP(A3,'1141 lookup'!AA:AF,5,0)) this one does the same as above but also adds the body of the email...

RX_ your post has reminded me i had made the psiot asking for help. I got the help needed. I will try to post the solution as it's at work and I'm at home. Sorry i should have posted that its resolved smiler44

I have a vlookup formula that creates an email and fills in the email address that can vary. I now want to add a subject to the email but the subject varies and also I don't want the subject to be shown as part of the vlookup result. this is the vlookup formula I have, how do I add the...

RX_ your right I'm still baffled. Do I use your code as a separate routine? How would I get from my sub to your sub? How do I add row numbers to the code? I did not know that could be done. I have spent hours trying to work out why my code fails. Searches on the internet etc have drawn a...

any reason for doing this apart from having all code in a module? smiler44

I thought i'd posted that I'd solved this. I needed to add userfrom1. to the front of the routine being called so call userform1.start for example instead of call start smiler44