Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Wichita, Kansas, USA
    Thanked 0 Times in 0 Posts

    Email Word form as an attachment automatically (MS Word 2003)

    We have a protected Word form.

    We need to send the form as an attachment, to an email address which is in the document text, automatically.

    I created a macro to copy the email address that is in the document, and then run the File- Send To - as attachment command. There are a couple of problems with the macro:
    1) When the email is opened, the user needs to click paste, to put the email address on the TO line. This isn't acceptable for the number of users of the form.
    2) I have the macro execute when the last input field is exited. The last field is a comments field and may or may not be entered and exited by the user.
    3) If the email address is moved to a different location in the document, the copy of it won't be correct

    Is there any way to automatically plug the TO line in the email from within the macro. I am familiar with VBA code, but haven't found anything through help yet.
    Since the form is protected, you can't just run the macro. Is there another idea of how I can automatically initiate the macro? Any other better ideas for any of this?

    Thanks! Patty

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Email Word form as an attachment automatically (MS Word 2003)

    The SendMail method in Word doesn't provide any way to specify the recipient. See Send an email from Word on the Word MVP site for two alternatives.

    You could provide a custom toolbar button to let the user run the macro.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts