Automatically e-mail Word Form to set e-mail address

[amandarose80]

I have created a form in Word for a department to use to submit their timesheets to three different people via e-mail. This file will either be accessed directly from where it is saved or via our intranet from a remote location. How can I set this form up so when they choose too it will automatically send the form to three set e-mail addresses?

 

[Dreamboat]

Try here:

http://www.mvps.org/word/FAQs/InterDev/SendMail.htm

Anne Troy

http://www.VBAExpress.com

 

[amandarose80]

Any other suggestions? This can only send it as an attachment, which means that I would have to open every single attachment from 3 different people, everyday. Thats the main problem with that code...

 

[Dreamboat]

Hmmm. You said "send the form to three set e-mail addresses".

Did you mean "send a link to the form..."??

Anne Troy

http://www.VBAExpress.com

 

[Dreamboat]

And what will the name of the form (document) be each time?

Anne Troy

http://www.VBAExpress.com

 

[amandarose80]

No, send it to 3 preset e-mail addresses. They would be the same e-mail addresses everytime. One person won't be printing them, I would be printing to the use as comparison for invoices, and the third person would be printing them to enter them in the company time tracker.

 

[Dreamboat]

Amanda:

Sorry. You're not getting my questions, so I'm going to try to clarify...

You have a Word form.
It must have a file name, does it not?
What is the name of it?

You say you want to email it to 3 different addresses.
Do you want to email the form AS AN ATTACHMENT to those 3 email addresses? or do you want to email a LINK TO THE FORM to those 3 email addresses?

Do all of these people use Microsoft Outlook? Or must it work for anyone, regardless of their email program?



Anne Troy

http://www.VBAExpress.com

 

[amandarose80]

I want the word form to become text within the e-mail that will be sent.
Not an attachement, not a link.
The three people will either be using MS Outlook or webmail via MS Outlook.

 

[Dreamboat]

The first piece of code under item #2 at:

http://www.mvps.org/word/FAQs/InterDev/SendMail.htm

does NOT send it as an attachment. See the comment in the code that says:

'The content of the document is used as the body for the email

I believe you can change this line:
.To = "recipient@mail.com"
to something like this:
.To = "recipient@mail.com; anotherperson@mail.com; thirdperson@mail.com"

And you can remove the .CC line if you like.


Anne Troy

http://www.VBAExpress.com