VBA

[tinyjo]

Well, aren't I just the clever clogs. I've finally managed to write my first macro completely from scratch in VBA. To explain. Normally if I want to write a macro I'll record one of me doing whatever the task is and then go into the code and edit it until it does exactly what I want. This means that I don't need to know to much of the object model as the code provided by the recording makes it fairly clear what I need to use. Unfortunately, Outlook doesn't allow you to record macros. I don't know why (maybe it's a security feature) but there you are. But I have a daily task which currently I accomplish by going the long(ish) way round that I really want to automate. So yesterday I decided "Right. I'm fed up with this I'm going to sit here and fiddle until I've automated it." So I looked at the object model in the help and the examples and sat down and fiddled and lo! I have now written a macro which actually automates my task and put the button on the toolbar. All by myself :) And I've finally worked out how you're supposed to use the debuggers in MS stuff, which I'd never got the hang of before - they're actually quite clever really :)