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
.Introduction = "Please read this and send me your comments."
With Documents("C:\Documents and Settings\xxxxx\Desktop\Template\To.doc").MailMerge
.MailAddressFieldName = "firstname.lastname@example.org"
.MailSubject = "Service Info"
.Destination = wdSendToEmail
I hope you can help me!!!! Danke, Danke, Danke!!!!