Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Sending an automated reply using Outlook Redemption...

Posted on 2003-11-21
11
546 Views
Last Modified: 2007-12-19
Is there a way to reply to an e-mail using Outlook Redemption? I'm setting up a Access application to save the emial that comes through a certain account (Sorted by an Outlook rule) and I'd like it to send an reply automatically.

Any help would be appreciated
0
Comment
Question by:will_scarlet7
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9798834
Something like this?

Sub SendAutoReply
    Dim appOutlook As New Outlook.Application
    Dim msgReturn As Object
   
    Set msgReturn = appOutlook.CreateItem(olMailItem)
    msgReturn.MessageClass = "REPORT.IPM.NOTE.IPNRN"    ' it's like a return receipt!!
    msgReturn.To = "mail@mycompay.com"
    msgReturn.Body = "Received your e-mail"
    msgReturn.Send
End Sub
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9798861
Don't forget to reference your Microsoft Outlook x.0 library!
Menu: Tools -> References
0
 
LVL 15

Author Comment

by:will_scarlet7
ID: 9798994
Thanks wsteegmans

However since I'm not running an Exchange Server, I'm using redemption to work arount the security warnings in Outlook.

(Running Outlook XP)
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 7

Accepted Solution

by:
wsteegmans earned 250 total points
ID: 9799074
0
 
LVL 3

Expert Comment

by:fcfang
ID: 9799696
If you don't want to rely on Outlook (painful at best), try this dll

http://www.freevbcode.com/ShowCode.Asp?ID=109

I've used it in my applications successfully (and no, I'm not a telemarketer/spammer :-P )
 
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9799774
fcfang,
It is a nice solution, but doesn't work very well in Access (missing some OCX-files).

will_scarlet7,
A really simple E-mail thing in Access: DoCmd.SendObject, like this.
DoCmd.SendObject , , acFormatHTML, "sendto@company.com", , , "MySubject", "My Body Message text ...", True

It uses your default E-Mail Client. Don't know how it reacts with Outlook XP.
0
 
LVL 18

Expert Comment

by:lludden
ID: 9800107
I have had great luck using this software.

http://www.emailarchitect.net/webapp/smtpcom/developer.asp
0
 
LVL 3

Expert Comment

by:fcfang
ID: 9801978
wsteegmans,

I actually do use this in Access by creating a reference directly to the dll.
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9802205
fcfang,

But using it on a PC without VB6, you're missing the OCX: MSWINSCK.OCX.

OK, you can download it here ...
http://lettermanstationery.tripod.com/vbruntimes.htm
0
 
LVL 15

Author Comment

by:will_scarlet7
ID: 9802349
Thanks guys for your input. I'm trying to stick with using Outlook though rather than using an 3rd party SMTP.
0
 
LVL 15

Author Comment

by:will_scarlet7
ID: 9802441
I figured it out. I guess it shows how green I am at programming by how simple the solution ended up being (reply line is anoteated below with "•¤•"
I'll include the code below in case anyone else is interested in using it:
*****************************************
Sub RedemptionMail()

Dim oOutlook As Outlook.Application
Dim oFldr As Outlook.MAPIFolder
Dim oMsg, oReply As Redemption.SafeMailItem
Dim mSender As Redemption.AddressEntry
Dim mSendQue As Redemption.MAPIUtils
Dim oMessage As Object
Dim oNs As Outlook.NameSpace
Dim mSubject, mFrom, mBody As String

Set oOutlook = New Outlook.Application
Set oNs = oOutlook.GetNamespace("MAPI")
Set oFldr = oNs.PickFolder
Set oMsg = CreateObject("Redemption.SafeMailItem")
Set oReply = CreateObject("Redemption.SafeMailItem")
Set mSendQue = CreateObject("Redemption.MAPIUtils")

oMsg.AuthKey = "*******"
oReply.AuthKey = "*******"
mSendQue.AuthKey = "*******"

For Each oMessage In oFldr.Items
    oMsg.Item = oMessage
    oReply.Item = oMessage.Reply ' •¤• Create reply to original message •¤•
    oReply.Body = "Testing Auto Reply"
    oReply.Send
    mSubject = oMsg 'Get e-mail subject
    mFrom = oMsg.SenderName 'Get e-mail SendersName
    Set mSender = oMsg.Sender
    mFromAdd = mSender.Address
    mBody = oMsg.Body 'Get e-mail message body
Next oMessage

mSendQue.DeliverNow

Set oOutlook = Nothing
Set oNs = Nothing
Set oFldr = Nothing
Set oMsg = Nothing
Set oReply = Nothing
Set mSender = Nothing
Set mSendQue = Nothing

End Sub
*****************************************

The cool thing about this is that I did not get any of the standard security warnings, and since I am using Outlook I have a copy of the replies in the "Sent Items" folder.

Note: Since it seems that installing redemption could open a exploitable hole in the mail system of my PC, I set it up to require a AuthKey.

I'm not sure how to close this as I ended up working it out myself.
wsteegmans I guess I could give you the points since you provided me with the most help on Redemption.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question