Using Access 2007.

I have been doing a bit of research and I think I need Redemption for
this (as far as I understand, the CDO stuff that comes with Outlook is
limited).

Initially I will manually create a "Parent" Exchange Public folder
called "Clients".

Once I have created that Parent folder here is what I want to do
programmatically:

1. Create an email with attachments.
2. The Onclick event of the SendEmail Button should:
a) Attempt to send the Email.
b) Check if the email was sent successfully
c) If OK, create an Exchange folder for the client in the main
"Clients" folder
d) Place a copy of the sent email in the client's folder

Should I be doing all of this with Redemption or does Redemption only
come into play when sending the email? In other words, should I have
one "Redemption" function that deals with actually sending email and
other non-Redemption functions to perform all the checking and folder
creation? I have tinkered with CDO and MAPI and had a poke at
Redemption, but I am a bit lost. I have written some fairly complex
systems with plenty of VBA, but I haven't done that much coding in
this area.

Can anyone give me some code chunks or pointers to get me started?

Thanks,

Paul

Not sure if it will do all you need, but take a look at vbMAPI. It's cheaper
and gets included in your Access project. No outside component and support
is excellent.
http://www.everythingaccess.com/vbMAPI.htm


--

AG
Email: npATadhdataDOTcom


"Paul H" <comcraft1966 (AT) googlemail (DOT) com> wrote