Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Mail merge multiple Excel rows to one eMail?

3 views
Skip to first unread message

Jim

unread,
Feb 25, 2008, 3:50:37 PM2/25/08
to
Is there a way to merge data from multiple rows in Excel to a single
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 an eMail generated for each student that lists all 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?

0 new messages