Easy question.....

[Jeremy Leeder]

I wrote a macro to send a document write to your email. But I was wondering how to automatically set who it is sent to. Something like .To = "[email protected]"
Here is the code now.

Dim Ans, Msg
Msg = "Do you wish to E-mail this form?"
Ans = MsgBox(Msg, vbYesNo + vbQuestion, "E-mail Form")
Options.SendMailAttach = True
If Ans = vbYes Then Word.ActiveDocument.SendMail
If Ans = vbNo Then End

This opens Outlook 98 but I know the useres will forget to enter the right email address. So it has to be pre-specified.

if you look in the DEMO PROJECTS link in the right-hand-side of this page, and look for "Creating Emails" there is a small bit of code to download and play with, this may be of use to you.