I don't know how to phrase this in search engines to convey what I want so I thought I would check with you intelligent people here

I have a form that is filled out by employees, and I would like to have a hyperlink that says "Click here to email to John" and after you click it, it opens outlook (already configured), and just puts the document as an attachment onto the email. Is that possible?

Hi
Yes this is possible. Follow the steps below:
Select the cell where you want the command to sit.
Select Insert followed by Field.
Scroll down to MacroButton and click on it.
In the Display Text box enter something like "Send Mail".
In the right hand column scroll down to the command FileSendMail and click on it.
Then click OK.
Then protect your form for Filling in Forms.
The double click on the Send Mail box and your fomr will be attached to an email.
Good luck.
Tony(OTPM)

I have a similar problem as JaHoffman above. But using Word 2007 I can find no Field to Insert from the menu list as described by OTPM.

There would seem to be quite a few people with the same dilemma yet I have not found a solution in any of the searches I have done thus far.

Basically, I have created a form which contains several text areas where a person provides comment/remarks. The same form is then forwarded as an attachment to the next person by way of an email hyperlink contained within the form. This process happens 3 times before going back to the originator. All this is contained on one page.
The hyperlinks work fine apart from not attaching the actual form when clicked.

Any help in solving this issue would be greatly appreciated.

Hi All
Please find herewith an example which you can use. The code is contained in the MacroButton so you can copy it to any document to use. Any problems please let me know what the issue is and I will see what I can do to help.
Make sue you save it as a MacroEnabled document and also protect the document for "Filling in Forms".
Good luck.
Kind regards
OTPM

Attached Files

Send Mail Example with MacroButton - Word97-2003 Format.zip (11.9 KB, 19 views)

Thank you for your reply & assistance.

Is there a way to edit this macro to include a specific e-mail address?
The form I have created is being sent to 3 different people, in turn, for review/remarks in a specified text box then forwarded to the next recipient.
I think I really need to create 3 macros, each with a different e-mail address to make this work?

I have attached the example form.

I appreciate any help you may be able to offer.

Hi
Replace the current code on the button with this (cut and paste):

Private Sub Send_Mail_Click()
Dim OL As Object
Dim EmailItem As Object
Dim Doc As Document

Application.ScreenUpdating = False
Set OL = CreateObject("Outlook.Application")
Set EmailItem = OL.CreateItem(olMailItem)
Set Doc = ActiveDocument
Doc.Save
With EmailItem
.To = "otpm@blueyonder.co.uk; tk_hussar@hotmail.com; tk_hussar@hotmail.com" 'CHANGE THESE EMAIL ADDRESSES TO THE ONES YOU WANT TO USE.
.Subject = "Completed Flight Safety Occurence Form"
.Body = "Please find herewith completed Flight Safety Occurence Form for your action."
.Importance = olImportanceNormal 'Or olImprotanceHigh Or olImprotanceLow
.Attachments.Add Doc.FullName
.Send
End With

Application.ScreenUpdating = True

Set Doc = Nothing
Set OL = Nothing
Set EmailItem = Nothing

End Sub

You need to change the email addresses above as indicated. This code will send the emails without activating Outlook. Use a test email address first to test the routine.

Let me know how you get on.

OTPM (Tony)