As I indicated in my original post, I have already looked at Cindy's page,
but her instructions don't really articulate where to put that code, and what
the difference is between Access and Excel.
"Peter Jamieson" wrote:
Word isn't very good at this kind of thing. You may be able to use the
DATABASE field approach described on Cindy Meister's pages at
http://homepage.swissonline.ch/cindymeister/
- see Mailmerge FAQ, Special Merges, Multiple Items per condition.
Not sure whether that will work with a merge to e-mail.
Peter Jamieson
"KarenB" wrote in message
...
I am attempting to create an email merge that will send a memo to each
manager outlining staff scheduled to attend training.
I have an Excel spreadsheet that has a list of all staff and includes a
column with the manager's name.
I need to create a single email for each manager that includes a table
with
all staff currently reporting to them (name, employee number, training
location, date of training). There is a column for each of these values
in
the spreadsheet.
Example:
To: ManagerName
The following staff are scheduled for training:
First Name Last Name Employee Number Location Date
------------ ------------ -------------------- ---------- -----
Joe Smith 1234 Vanc May 15
Fred Brown 2345 Tor May 18
I thought I was on the right track when I found Cindy's
explanation/website
(http://homepage.swissonline.ch/cindymeister) discussing the creation of
Customer Invoices, but after spending quite a bit of time looking at the
example, it still wasn't clear to me how to make this work with an Excel
spreadsheet.
Please help?