Trying to automate the email process???

[ajsanders]

I've been working with Access for about 2 weeks now. I have a table of data in which a lease end date is listed among other things. I have a query that shows all accounts that have a lease end coming up within 8 months. I have created a form that I want to send out to the reps that they can fill out and send back to update the original table.

What I want to do:
1: Automate the email process.
2. Send out based off of a data in the table.
3. Send to an email all in the table.


3. Have the form that the rep can check boxes to update data. (HTML??? Rich Text?? etc)

Can I use a Macro? Is there conditions that can help solve this? Do I need to use VBA in excel? Thank you for your help in advance.

[ItsMe]

Perhaps it will be easier to email a report than to email a form. You might be able to build a report based on the same query your form is bound to.

[ajsanders]

Perhaps it will be easier to email a report than to email a form. You might be able to build a report based on the same query your form is bound to.

So I created a report and under the external date tab, email is not an option. Is there a way to email the report?

[ItsMe]

There are several ways. The simplest, in my opinion, is to use VBA.

The following, sends a report.

Dim strSubject As String
Dim strBody As String
Dim strReport As String
Dim strTo As String
Dim strCc As String
Dim strBcc As String
strSubject = "Insert Subject Line Here"
strBody = "Insert text to be displayed in the email body"
strReport = "rptEquip"
strTo = "you@gmail.com"
strCc = ""
strBcc = "me@gmail.com"
DoCmd.SendObject acSendReport, strReport, acFormatTXT, strTo, strCc, strBcc, strSubject, strBody, False

If you need to filter specific records to include within the report, you can open the report before emailing by adding a line of code.

The other option is to create a macro which I do not use because I do not build applications for use over the internet. I thought it would be easy for me to Google an example of building a macro but I could not find a decent example.

[ajsanders]

Ok. So I'm trying to email it to the data to the corresponding email field. Is there a way to do that or does it have to go to whatever email i put in after -strTo = -

[June7]

Common topic. Search forum and Google. Here is a start:

https://www.accessforums.net/import-...ook-18221.html

https://www.accessforums.net/access/...ect-17713.html

[ItsMe]

strTo is a variable. You can assign whatever value, as long as it fits into a String Variable, you want to strTo.

There are various methods to retrieve data. DAO may be a good way to retrieve data. You could loop through a recordset and as you move to a new record, you can assign a specific field to strTo. You could also assign a specific field to the other variables like, strReport, strCC, etc.

This thread may be beneficial to review
https://www.accessforums.net/program...ail-42585.html

[ajsanders]

ItsMe, thank you so much for your help. Everything is working as I planned in the beginning. Awesome stuff!!!

[ItsMe]

Glad you were able to accomplish your task.