Outlook : Select Address of a Contact

Guess you need to process the items of the Recipients Collection Object, see: http://msdn.microsoft.com/en-us/libr...CHG.10%29.aspx

Nic;o)

Thanks Nico.

I was already looking at the Recipient object of course, but your link pointed me at a resource that explained it better than what I'd found in the Help system. Obviously I'd Googled, but hadn't found what I needed.

When I have finalised my code (after finalising my understanding of course) I'll post some more info for anyone else to find with similar problems.

Cheers :)

PS. The bit I found that I think most likely to give me what I need is http://msdn.microsoft.com/en-us/libr...EXCHG.10).aspx.

Hey Neo. I am working on a new project and will need to implement an email portion. When you are done can you send me some stuff you did maybe I can use some of it. It will save me a lot of time. I'm not quite ready for that aspect but should be in a couple weeks.


cheers,

Just let me know nearer the time. I will have made more progress then.
You can also let me know (then) exactly what you're looking for.

PS. I should warn you that this code does fall foul of fairly annoying Outlook warnings that non-Outlook software is trying to (1) access addresses and (2) send email on your behalf.

This is something I intend to progress with, but to date I've hit problems.

Instead of Outlook you might try the CDO object for emailing.
Check: http://www.paulsadowski.com/WSH/cdo.htm

Nic;o)

That looks very interesting Nico - Thanks.

I am most of the way there using the standard Outlook object model, but this one may prove a better solution for me. I will certainly look into it and post back my comments. That may be a bit delayed though, as I am now working on another aspect of this particular project where I have to dig up the correct data that later will be e-mailed or FTPed across to the customer.

I know nothing about CDO at this time, so I will need to read up some. I do know that the firewalls we have here will disallow any SMTP traffic from anywhere but a few well restricted servers (and all the Exchange servers are set not to allow SMTP relaying). Had it not been for that I think I would have been happiest simply knocking an SMTP solution together.

All this because a bunch of personality-less morons decided to use the internet to spread their detritus. Anyway, all good fun.

PS. From my initial research it seems that CDO does use the SMTP protocol exclusively, which puts it out of scope for me I'm afraid.

I will update the thread with any progress I make using Outlook automation.

I will include here a link that was passed to me that may prove promising (Avoiding Excessive Security Warnings when Sending Automated E-mail Messages). This deals with problems I have already encountered using this method. Hopefully this link will enable me to get around them.

Good link NeoPa, shows that when SMTP is allowed the CDO is the easy way to "bypass" the Outlook Object model build-in warnings. Guess the "morons" found that too <LOL>

Nic;o)

I'm afraid so Nico. There was a flood of virus payloads which included a basic SMTP engine that ran on the PC itself :(

I first found that out when an Exchange server I was responsible for was flagged as an open relay (it would allow SMTP messages to be sent on when it determined the address was not local). I had to fix it and then apply to be rechecked before I could get it removed from the blacklist (Various servers were refusing to accept any mail from us).

It seems there were two methods used by the virus software :

1. SMTP via the local mail server. This gives the e-mails the impression of being more kosher.
2. SMTP straight out to the web.

To block the first I needed to tighten up the security on my Exchange server. To block the second I needed to block SMTP traffic on the firewall from all internal addresses except my Exchange server.

As you will see, this doesn't leave much scope for a general purpose SMTP based routine in my code :(

Hello Neo,

I am now ready to look at the e-mail part of my app. Would you mind sending me anything you have got working (in particular how you got around the security messages). I will even trade if need be. I just created a very nice Calendar that allows you to add events such as meetings, to-do, etc., multiple participants, and such. I could trade you that if a calendar/scheduler is of any use to you.

You can PM me for email address.

cheers,
Rob

Rob,

My e-mail project has been delayed further.

I am now using FTP to transfer this current set of files to the customer, although I would like to include e-mailing in my repertoire once this is finished. I hope to reduce the manual workload considerably by enabling this.

I haven't made much further progress than my last post on this though I'm afraid. I have the ability to code the sending of the mail, but the security is something I've only found links for.

I suggest, unless you have similar restrictions yourself with respect to SMTP, that you check out what CDO can do for you (Re Nico's post). If not, check out my earlier link and see if you can make some progress with that.

PS. Thanks for the offer of your code. I'll bear it in mind if ever I need something along those lines. I'm also more than happy to share anything I manage to come up with if it can be of any use to you. Unfortunately, that's not likely to start for some weeks now, and even that's assuming other priority work is not inserted ahead of it (I hope not though as this is something I really want to get cracked).

This module (only half-finished I'm afraid) is as far as I've got so far. Nothing's finished yet (specifically some comments not implemented yet) but SendEM can send an email - albeit with all the security popups getting in the way :(

Thanks. I just started to look into the email problems and it looks like Extended MAPI might be the way to go instead of standard MAPI. Extended MAPI eliminates the problems of popups. If I get the Extended MAPI to work I will let you know.

cheers,

Cheers Rob.

If that proves true (& I may get to start looking again in mid August sometime if things go according to plan) then I too will be very interested.

If I get anywhere I'll keep you posted :)

Did you ever get anywhere with this Rob?

I'm not working on it again, but I'm still interested to see code reflecting a technique that can both be safe, and bypass the security warnings.

@NeoPa
Sorry for the delay Neo. I haven't checked for a few days. I am intending to try to get this working http://www.codeproject.com/KB/IP/CMapiEx.aspx. I have talked to the developer and he thinks it should work but has not tried it in VBA. It does work in VB.

I did not have time for my project to check in detail so I had to go with a commercial version so I went with MAILBEE.

But I would like to try and get the above free version working. When I get time I will look into it some more.

cheers,

Sounds interesting. Likewise I don't have the scope to devote time to this at work atm. I'll catch any future posts on here though. Also, I'll post if I manage to get any progress myself.