How-to: Create send Word document as email attachment button????

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C.R. - 13 Jan 2006 20:58 GMT

I have posted on this before and thought I had it working. But it is
not. I have a form that I created that I want to send to managers and
such in my company. I would like to have a button that they can click
on inside the document that will automatically send the file as an
attachment in Outlook.

I have tried clicking on the E-Mail button, but it does not always come
up on some clients. I have tried to create a Command Button that has
the following code:

Private Sub CommandButton1_Click()
ActiveDocument.SaveAs ("C:\\Employee Access Request Form.doc")
Options.SendMailAttach = True
ActiveDocument.SendMail
End Sub

Which doesn't work on all clients as well because of our default Macro
security is set to high.

Is there any way to do this without using Macro's????

Reply to this Message

Cameron Dockstader - 28 Jan 2006 01:24 GMT

I also could use the solution to this problem, only, I would also like to
fill in the To: field in Outlook!

If anyone knows how, let us know!

I tried playing in the Insert: Field tool but couldn't find anything relevant.

> I have posted on this before and thought I had it working. But it is
> not. I have a form that I created that I want to send to managers and
[quoted text clipped - 16 lines]
>
> Is there any way to do this without using Macro's????

Reply to this Message

Doug Robbins - Word MVP - 28 Jan 2006 06:29 GMT

See http://www.slipstick.com/addins/mssampleapps.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I also could use the solution to this problem, only, I would also like to
> fill in the To: field in Outlook!
[quoted text clipped - 24 lines]
>>
>> Is there any way to do this without using Macro's????

Reply to this Message