I would like to know if it is possible:
I have a word dokument which has to be distributed to a couple of persons. I was thinking to do the checkboxes. Names whos checkbox is checkt shoud automaticly receive the copy of the document. Is this possible? And if yes, how. Can somebody help me?

Hi Marindi
I am sorry but I am not getting the slightest idea of what you want to do. describe in detail your box, how the addresses are read? (Email addresses?) And how the recipients are going to receive “automatically” the document per fax, per email? Please describe precisely the whole scenario and try to name all the objects and their functions (of the scenario) otherwise we simply give up…

first of all thank you very much for the answer. I was in Germany last week. I already gave up with this because nobody answers for days. I never did any thing with VBA before. I saw you come from Germany? Do you speak German?

Problem: I have a word document with checkboxes (5). If you check a checkbox the person should receive a email with the document attached. The best would be if more then one box is checked then one email should be send with all the recipients (and not a extra mail on each one. I want to have a note too. Something like: "The document has been send to the following recipients: P.Blue, M.Red, B.Green...".
But first I want to get it work!!!!
I start to write the code.But it doesnt work...!!!

Here is a code that I start to write.

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
Options.SendMailAttach = True
With Application.ActiveDocument.MailEnvelope
.Introduction = "Please read this and send me your comments."
With Documents("C:\Documents and Settings\xxxxx\Desktop\Template\To.doc").MailMerge
    .MailAddressFieldName = "[email protected]"
    .MailSubject = "Service Info"
    .Destination = wdSendToEmail
    .Execute
End With

    End With
End If
End Sub


I hope you can help me!!!! Danke, Danke, Danke!!!!