Morning

[Robert Couchman]

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

 

[Tom Ogilvy]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm



You just need to divide up your data into separate tables I would imagine.