mail merge + attachement

[Erik Thorstensen]

I am working with a survey that is to be sent to a number
of respondents - all of whom are in the 2002access-
database. It is to be sent by e-mail and I would like to
attach our questionnaire in a personalised form
<<firstname>> <<lastname>> etc so that our respondents
should not be bothered with filling in the details we
already have.

Then I stumble upon the first problem: How to combine the
right e-mail with the right questionnaire?

I have tried to send out mail merge without a
questionnaire - and that works ok.

Then I tried to send out the questionnaire as an
attachemnt in a mail merge but then I get no option as to
how I can edit the text of the e-mail. If I try to do
that the e-mails "forget" their attachment.

Even if I run a mail merge on an e-mail to which I have
already attached the questionnaire, but when I send it,
it "forgets" the questionnaire again.

Any suggestions?

Thanks in advance,
Erik

 

[SA]

Erik:

You haven't discussed how you are attempting to do any of the methods you
discussed. Its sounds as if you are doing this from Word, and not from
within Access; i.e. Access is only serving as the data source for the e-mail
addresses. To properly make suggestions, you might also post the code you
are using in Word, as there may be and issue that can be resolved there.
You might have tried posting this to the Word newsgroups to benefit from
power users of there. (Which I've done with this reply.)