Search:

Thank you. I would never have thought of looking all the way in there.

regards

Alan

I made a mistake and turned automatic numbering off (I was asked by Outlook and said "yes" - silly me). I can't find any way of turning it back on. Anyone know the magic to do that?

regards

Alan

Just as an FYI, I found this section from MS http://msdn.microsoft.com/en-us/library/office/microsoft.office.interop.outlook._mailitem_members.aspx which proved very useful. So, rather than cc'ing...

I found some code
Dim objNS As Outlook.Namespace
Set objNS = Outlook.GetNamespace("MAPI")
msgbox objNS.Session.CurrentUser.AddressEntry.GetExchangeUser.PrimarySmtpAddress


but that needs a...

As the title says, I need the SMTP address from Outlook of the user running my code so I can 'CC' them when they email a message.

I can do the email bit - but I can't work out how to get the SMTP...

As far as I can see it also only works on encrypted FILES, not encrypted DISKS which boot up before the O/S. So, maybe that's the way forward? How secure are tools like Macafee Endpoint Encryption?
...

Interesting - does office365 also do contact sync? I've seen email (which I don't need) and Calender - but not contacts.

I may have a play with Exchange

ALan

Absolutely. But I'd also like integration with Android - which I know Exchange can do as I have it via my works email (I work for HP).

But I'd like a separate system for my home email - I thought...

Thank you - but I don't want web access to a calender (quote "web access to email, calendars, and contacts") - I want it integrated into my home Outlook and my Android devices - same as I have for...

A hosted option would be fine except that Google have just dropped Gsync (Active-Sync to Gmail) and Outlook.com is (as fas as I can make out) just Hotmail renamed and has no calender or contacts...

I am lucky enough to have some spare PCs and a subscription to MSDN so....

I would like to set up Exchange so that I can have once central copy of my contacts and calenders which I can use for my...

That's OK - if the colour changes, I'll do a manual recalc.

Cheers

Alan

That macro works EXACTLY as I want. Brilliant. Many thanks

Alan

Humm - not quite that easy. I have manually set up certain cells with a colour to highlight things. It would have been nice if there was an "IF" type statement such that Could do an "IF(colour=blue,...

I want to sum a selection of cells based on the colour of the cell. Is that possible?

thanks

Alan

And after testing, it does EXACTLY what I want. Yippee!!

Alan

I do have a paid up MSDN subscription. Installing Pro now. I've also found this site http://8gadgetpack.bplaced.net/ which may do what I want.

Alan

Parameters won't do it. The queries are all quite different.

I like the switchboard idea though. I'll have a play.....

I have an MS-Acces 2010 database with about 15 tables. I'm creating loads of queries to answer specific questions. However, the list is growing quite large and it's getting a bit unwieldy. Is there...

Thanks all for this. Where can I find the 64 bit version? The pointer only seems to have the 32 bit version. or, should I be getting it from my Windows 7 system?

I will re-install the Win 8 Pro...

Having used Win 8 RP for a while whith my gadgets loaded (CPU, Clock, calender, App launcher), I am extremely disappointed that I can't load them up in the final version. Has anyone tried to find a...

Thanks

Alan

Thank you. I've learned something new today

Alan

I have a simple formula which copies text up to an underscore from one column to another. It's "=LEFT(D36,SEARCH("_",D36)-1)" (cell D36 contains ABCDEF_1234 or something similar.

If the text in...

Yes, nice thinking. I like that.

Thanks

Alan