Question Email reply from ms access

[nitsha440]

Hi,

I am using MS Outlook 2007 and Access 2007, I have made the connectivity of both by which i am now getting emails in MS access DB, now i want to use the Access DB to reply to those emails without using Outlook. I want the Sub and the text in the reply to be reflected in same way as we get when we reply using outlook, if any one knows how to do it please do let me know.

Thanks,
Nisha

 

[Trevor G]

Nisha welcome to the forum,

You can use VBA code to deal with this, is it a reply to single email addresses or are you looking for bulk replies

You will have to create a form, but here is some code I use to get people to send me an email if they don't have permissions to get into a database.

You will have to set the Rference to Use Outlook in the VBA Screen

Sub sendForApproval()
'*************************************************
'VBA Code created by Trevor G November 2009
'Emailtrevorg
'*************************************************
Dim olApp As Outlook.Application
Dim olMail As MailItem
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
With olMail
.To = "trevor.g"
.Subject = "Access Request"
.Body = "Please can you provide access to the system." & vbCr & vbCr & _
"The required details are as follows my First and Last Name is: " & vbCr & _
"My User ID is: " & vbCr & _
"My Computer Name is: "
.Display

End With
Set olMail = Nothing
Set olApp = Nothing
End Sub

 

[NigelShaw]

Hi,

now i want to use the Access DB to reply to those emails without using Outlook.

Thanks,
Nisha

Hi,

you can use the SMTP routine for sending emails without using outlook.


do a search here as there are plenty of samples

Nidge

 

[nitsha440]

Hi,
Thanks a ton to both of you for looking into this, Now let me tell you what i have done exactly, I have Connected Outlook and Access DB and now i am getting all the emails in my Access DB which i have linked to Outlook, what i want now is i want to reply to those emails which i am getting in my access DB instead of Outlook i get lots of email in a day and wants to reply to those emails from Access there is no specific user to whome i email everyday and there is not list of user's, its like whatever i get in my Inbox i get that in Access DB and now from there i want to reply, Please suggest how what is required to get this done.

Eagerly looking for the reply ASAP......... Thanks in Advance

Nisha

 

[dbDamo]

You wish to send a standard reply to every email you receive?

Do your emails get imported into your Database once a day, at regular intervals or as soon as they are received?

Once you answer these questions I am sure that I can help you

 

[nitsha440]

You wish to send a standard reply to every email you receive?
a. No, there is no standard formate, whatever email i receive in my inbox it is reflected in Access DB i have linked DB and Outlook as i have mentioned earlier also now i have form created in db with the fields name [ ID, To, CC, Subject, Content, Received time, Modified time], Now i want a button to be created on same form on which if i click a box will appear and i will put the ID number of the email i want to reply afer which email gets open in the same Outlook formate with the SUBJECT as RE: Subject line. Please refer to the formate below:

IT IS JUST AN EXAMPLE

========================================================
To. ..........
CC........
Bcc...........
Subject........RE: Subject line.

Reply which i want will be typed Manually.

Regards,
Nisha

-----Original Message-----
From: ABCD
Sent: Wednesday, September 22, 2010 5:40 PM
To: ABCD
Subject: ABCD
=========================================================


Do your emails get imported into your Database once a day, at regular intervals or as soon as they are received?

B. Email gets imported every time i refresh my DB.

Seek your reply soon. Take care

Nisha