go to David McRitchie's site - he has a lot of information on using the
mailmerge
http://tinyurl.com/2w5s9
url to do a google groups search:
http://groups.google.com/advanced_group_search?hl=en
here are some more specific links:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm
http://www.mvps.org/word/FAQs/MailMe...DataSource.htm
You just need to divide up your data into separate tables I would imagine.
--
Regards,
Tom Ogilvy
"Robert Couchman" wrote in message
...
Good morning everyone, i hope you are feeling nice and
refreshed!
is anyone able to help me, i am looking for some help with
using VB to merge excel data with a word document for a
mail merge, BUT!! there are different letters that need to
be sent to different people...
i.e.
people who have passed application -- letter invite to
test (with dates and location to be transfered)
people who have passed test -- letter invite to interview
(times and dates stored on excel)
people who failed test -- letter saying they failed
People who passed interview (high score) -- letter
informing them of where and when they are to start
(details will be held on excel)
people who passed interview (low score) -- letter
informing they are on a waiting list
People who failed interview -- letter thanking them for
attending
-------------------------------
**ALL THE DETAILS OF NAME AND ADDRESS ARE HELD ON EXCEL
SPREAD SHEET NEXT TO THE PERSONS NAME**
-------------------------------
if anyone would like to help me please post a thread and i
will explain in greater detail.
Thank you,
Robert Couchman