Is there a way to merge data to an eMail? I have 10,000 students in
our current class registration system that we are going to shut down
in a few months. Each student has history of the courses that they've
taken that are kept in our current system that will not be ported over
to our new system.

I want to have Access eMail each individual with the courses that
they've taken. Is that possible? I'd like each user to get only one
eMail, regardless of if they've taken one course or five... something
like shown below:



-----------------------------------------
John Smith

Date 05/15/07
Course Intro to Word
Status Attended

Date 08/14/06
Course Benefits orientation
Status Attended

Date 06/15/06
Course New Hire Orientation
Status Attended


It is possible? Is it possible with Excel/Word merge to mail?

On Mon, 25 Feb 2008 12:46:35 -0800 (PST), Jim <jlrehmann (AT) gmail (DOT) com>
wrote:

You only need MsAccess. Just create a report and call it in a loop
over all students, and use DoCmd.SendObject to send it.

-Tom.

Jim <jlrehmann (AT) gmail (DOT) com> wrote:

That is so incredibly stupid of who ever is managing the migration into the new
system. Un fricking believable. Such a migration should only be a few days work at
most.

Yes.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

To create a formatted document to send as an email you will need to use VBA code to
create a largish string. This string will then be passed to the SendObject command
or other method as the body of the email. For more details including sample air
code see my Tips page on this topic at
http://www.granite.ab.ca/access/email/formatted.htm.

In your particular case you'd have a loop inside a loop to accumulate each student's
data into one email.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/