E-mail from database of names/employees

[Guest]

Hi,

Is it possible to send out a mass e-mail to a database of employees (all
having their own individual records) with personal information unique to that
recipient? My goal is to send information for each employee to update/verify
for my records.

Thanks!

 

[Guest]

Yes it is possible.

Your database will have to have a table with all the employees and their
email addresses which will relate to a report you generate on each of them.
Using the send object method and a looping routine you can email each
employee their perspective report using outlook.

 

[Guest]

Good afternoon. I am working with JDenise on this project. If I understand
correctly, I would need a macro that loops and runs a report for each
employee and then sends as a pdf to an email address using the File\Send
To\Mail Recipient as Adobe pdf.

If this is so, I can use some help on how to bulid this macro to run a
series of reports, one per employee. I can easily build a report that runs
one employee per page on a single report or a single report for one selected
person, but to sequence the selection through a list of employees and run
separate reports for each -- of that I am uncertain.

Thanks,

Greg S

 

[Guest]

The source for your report needs to be a query that will match the records to
the appropriate person based upon a form you will build that also includes
text boxes for the recipients name and email address.

Rather than building macros, you should practice building sequenced events
in the "OnClick" events of command buttons.

The following code:

Dim Whatever As ADODB.Recordset

Set Whatever = New ADODB.Recordset

Whatever.Open "table with email addresses", CurrentProject.Connection,
adOpenStatic

Do Until Whatever.EOF

[Forms]![frm_1].[txtfield1].Value = Whatever![Name]
[Forms]![frm_1].[txtfield2].Value = Whatever![E_Mail]

On Error Resume Next
DoCmd.SendObject acSendReport, "YourReport", acFormatSNP,
[Forms]![frm_1].[txtEmail], , , "emailsubject", , True

On Error Resume Next
Whatever.MoveNext
Loop


The above runs through a table in your database that has a field for the
name and a field for the email address of those you want to send reports.
You build your form based on that table with txtboxes bound to those fields.
Your query which is the control source for the report you are sending is
referencing those fields to match the records you want in the report.

Good Luck