I need assistance which should be a fairly straight forward issue, but for some reason I am struggling with it!
1)I need to create a form in Word that I can save to a shared drive.
2) I need to allow users to complete the form and press a SUBMIT button
3) The submit button will submit the form to "ANOther Person" via Outlook. It will prepopulate the 'To' address, 'subject line' and part of the body, but leave it open for the user to alter or add to the body message.
4) Once ANOther person receives the email, they can then authorise the form and press another submit button which will send the form on to '[login to view URL]'
5) If possible, the form will go to the SomeOne Else, plus 2 other email addresses, either by CC or within the 'To' line.
This is what I have been using on a macro-enabled word document.
Private Sub CommandButton1_Click()
Dim OL As Object
Dim EmailItem As Object
Dim Doc As Document
[login to view URL] = False
Set OL = CreateObject("[login to view URL]")
Set EmailItem = [login to view URL](olMailItem)
Set Doc = ActiveDocument
With EmailItem
.Subject = "Initial Request for a Trip or Event"
.Body = "Dear Paul" & vbCrLf & _
"Please find attached my initial request for a trip/event" & vbCrLf & _
"Thanks"
.To = "email address of person authorising the trip"
.[login to view URL] [login to view URL]
.Display
End With
[login to view URL] = True
MsgBox "Your request has been submitted. Thanks!"
Set Doc = Nothing
Set OL = Nothing
Set EmailItem = Nothing
End Sub
However, when the person receives the form, it is blank.
Can someone please write code that will work.
Thanks
Good day! My name is k.R.. My principles
are simple, clean and beautiful in the details.
I am interested in your project because I have done similar projects in the
past. I am always ready to push you towards your success.
===
- Also, my fee is within your budget. Price can be flexible and affordable
for you. Please send me a reply to discuss in details.
- I would like to use my experience to serve you better. You can trust my
sincere attentiveness in both in quality and time. Count on me and I will
ensure that you're satisfied with your project.
- I have read and understand the project guidelines. I'm very interested in
the project because it is in my area of expertise. I'm sure we can work
well together.
===
$$$ You need to communicate with the world about the benefits of choosing
your company, and I am the exact medium you need..
* Please let me know if you have any questions. I am looking forward to
your positive response.
===
Many thanks, and I am always ready to work for you.
Best regards,
K.R