Vba script or mail merge for a task?

[kit]

Hi
We want to use a database in excel to notify children of a
competition result.It would be sent in an e-mail mail
merge.
Would like to have a field in notification message saying
they were either right or wrong.
If right one sentence is added to the letter or if wrong
another, (database has a right or wrong column).
I think mail merge could do this OK but the next bit is;
if they are right their name is then inserted on to a
certificate (which is a Word Doc)
We would then complete the merge process by adding the
certificate, if right, as an attachment to the merged e-
mail.
I can see where amerge could do some of this but am I
right in thinking VBA may be better?
If so some pointers as to how to do this would be
appreciated!
Thank you for reading this far!
Kit

 

[Doug Robbins]

I think you will probably need to do two merges one for the rights and one
for the wrongs. Then to handle the certificates for the "rights" see the
article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP