Reply to emails in Access - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Reply to emails in Access

Brent Davis

3 years ago

I have set up a form where I can write my email and send it via outlook with no problem, thanks to Richard's lessons. They are awesome! But how do I reply from access? After I send the initial email I just continue any other correspondence in outlook. I want to have the history in Access because my company emails delete from outlook after 30 days. Any assistance is appreciated!

Kevin Robertson @Reply

3 years ago

Add code similar to this in your Reply button.

Private Sub btnReplyToEmail()



   Dim objApp As Object

   Dim objMail As Object



   Set objApp = CreateObject("Outlook.Application")

   Set objMail = objApp.CreateItem(0)



   On Error Resume Next



   With objMail

      .To = "[email protected]"

      .Subject = "Re: Subject of email"

      .Body = "Body of email"

   End With



   objMail.Display   '.Send to send without previewing



   On Error GoTo 0



   Set objMail = Nothing

   Set objApp = Nothing



End Sub

To save a history in your database you can use some SQL to append the data to your table.

	Brent Davis OP @Reply 3 years ago
Thanks for the information Kevin! I will begin working on it.

	Brent Davis OP @Reply 3 years ago
OK, how do I get the reply to my initial email from outlook to access so I can reply to a specific email?

	Richard Rost @Reply 3 years ago
Sending an email from Access to Outlook is pretty straightforward. Reading email FROM Outlook into Access is a lot more involved. I cover that in my Access Email Seminar.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View