> Mike,
> Does anything show, if while you are in the Word VBA Editor and the cursor
> is in the word 'Save' of 'ActiveDocument.Save' and you then press the F1
> function key to bring up contextual VBA Help? Do you automatically get
> "prompt lists" while in VBA Editor and manually typing in the "." between
> legitimate object words and properties or methods? If you don't have
> contextual help or automatic prompt lists, then you'll know how the
> Macintosh Word VBA user feels. :(
> Did you install Word yourself? What version of Word?
> Click on this link for info on installing VBA Help:
>
http://tinyurl.com/pxovv>
> > Russ:
> >
> > A new problem....I did as you said and went into VBA help. The window pops
> > up but remains blank. I have tried it several different ways and the pop up
> > window for VBA help is always and remains always blank.
> >
> > Mike
> >
> > "Russ" wrote:
> >
> >>
> >>
> >>
> >> Mitch,
> >>
> >>> Below is the code I am using to send the form via email.
> >>>
> >>> Thanks for your continued help.
> >>>
> >>> Mike
> >>>
> >>> Private Sub Submit_Click()
> >>>
> >>> Dim bStarted As Boolean
> >>> Dim oOutlookApp As Outlook.Application
> >>> Dim oItem As Outlook.MailItem
> >>>
> >>> On Error Resume Next
> >>>
> >>> ActiveDocument.Save
> >>
> >> Read about the .Save and .SaveAs methods in VBA help and alter the above
> >> line accordingly using the options you want.
> >>>
> >>> Set oOutlookApp = GetObject(, "Outlook.Application")
> >>> If Err <> 0 Then
> >>> Set oOutlookApp = CreateObject("Outlook.Application")
> >>> bStarted = True
> >>> End If
> >>>
> >>> Set oItem = oOutlookApp.CreateItem(olMailItem)
> >>>
> >>> With oItem
> >>> .To = "mcloghessy[ at ]xanterra.com"
> >>> .Subject = "Print Shop Requisition"
> >>> 'Add the document as an attachment, you can use the .displaynameproperty
> >>> 'to set the description that's used in the message
> >>> .Attachments.Add Source:=ActiveDocument.FullName, Type:=olByValue, _
> >>> DisplayName:="Print Shop Requisition"
> >>> .Send
> >>> End With
> >>>
> >>> If bStarted Then
> >>> oOutlookApp.quit
> >>> End If
> >>>
> >>> Set oItem = Nothing
> >>> Set oOutlookApp = Nothing
> >>>
> >>>
> >>> End Function
> >>>
> >>>
> >>>
> >>> "Doug Robbins - Word MVP" wrote:
> >>>
> >>>> Show us the code that you are using.
> >>>>
> >>>> --
> >>>> 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
> >>>>
> >>>> "mptc" <mptc[ at ]discussions.microsoft.com> wrote in message
> >>>> news:E36556F9-AB39-442F-9834-DBDD0D3C02E6[ at ]microsoft.com...
> >>>>> Doug:
> >>>>>
> >>>>> Thanks for the tip, I tried several different codes but none worked the
> >>>>> way
> >>>>> I want. I guess what gave rise to this was the fact that in testing the
> >>>>> form
> >>>>> I filled out various fields and hit the "Submit" button and that worked as
> >>>>> planned (sending the completed form to me via email as an attachment).
> >>>>> After
> >>>>> that when I hit File > Close, Word did not prompt me as to whether I
> >>>>> wanted
> >>>>> to save the document or not. It just closed and automatically saved the
> >>>>> form
> >>>>> with the filled in fields.
> >>>>>
> >>>>> Why isn't Word prompting me as it usually does when Closing? Is there an
> >>>>> existing code that I need to change?
> >>>>>
> >>>>> Thanks in advance.
> >>>>>
> >>>>> Mike
> >>>>>
> >>>>> "Doug Robbins - Word MVP" wrote:
> >>>>>
> >>>>>> I guess by "within the form", you mean "within the document". I have no
> >>>>>> experience with the use of such controls directly in a document, but I
> >>>>>> would
> >>>>>> suspect that the procedure is just the same. You need to add some code
> >>>>>> after that which emails the document to reference each textbox control on
> >>>>>> the form and set its value or text property to "" For the checkboxes,
> >>>>>> you
> >>>>>> would set their value to 0
> >>>>>>
> >>>>>> --
> >>>>>> 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
> >>>>>>
> >>>>>> "mptc" <mptc[ at ]discussions.microsoft.com> wrote in message
> >>>>>> news:B2A3D30F-9D58-4D49-BA06-C705471EC9AD[ at ]microsoft.com...
> >>>>>>> I thought it was called a user form. It has text boxes, option buttons
> >>>>>>> and
> >>>>>>> check boxes within the form. I used the Visual Basic tools.
> >>>>>>>
> >>>>>>> Mike
> >>>>>>>
> >>>>>>> "Doug Robbins - Word MVP" wrote:
> >>>>>>>
> >>>>>>>> Is this actually a userform or do you have controls directly in the
> >>>>>>>> document?
> >>>>>>>>
> >>>>>>>> --
> >>>>>>>> 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
> >>>>>>>>
> >>>>>>>> "mptc" <mptc[ at ]discussions.microsoft.com> wrote in message
> >>>>>>>> news:C053C9DD-B23D-4AD0-B98D-76F70C623436[ at ]microsoft.com...
> >>>>>>>>> Thanks Doug, that did it! However, I have a follow up issue. After
> >>>>>>>>> completing the form and hitting the submit button, I don't want the
> >>>>>>>>> form
> >>>>>>>>> to
> >>>>>>>>> save the comments etc. IOW I want the form to revert back to the
> >>>>>>>>> blank
> >>>>>>>>> form.
> >>>>>>>>> I will receive the completed form via email, but the original form I
> >>>>>>>>> want
> >>>>>>>>> to
> >>>>>>>>> revert back to the blank form. I can save the submitted form and
> >>>>>>>>> the
> >>>>>>>>> individual departments can always save their completed form at their
> >>>>>>>>> end.
> >>>>>>>>> Is
> >>>>>>>>> there a code I am missing?
> >>>>>>>>>
> >>>>>>>>> Thanks!
> >>>>>>>>>
> >>>>>>>>> Mike
> >>>>>>>>>
> >>>>>>>>> "Doug Robbins - Word MVP" wrote:
> >>>>>>>>>
> >>>>>>>>>> In the Visual Basic Editor, you need to select References from the
> >>>>>>>>>> Tools
> >>>>>>>>>> menu and set a reference to the Outlook Object Library.
> >>>>>>>>>>
> >>>>>>>>>> --
> >>>>>>>>>> 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
> >>>>>>>>>>
> >>>>>>>>>> "mptc" <mptc[ at ]discussions.microsoft.com> wrote in message
> >>>>>>>>>> news:E09F6D49-1248-4A3B-8B59-9EA7639AA3E2[ at ]microsoft.com...
> >>>>>>>>>>> I have designed a User Form. It is a Print Shop Requisition with
> >>>>>>>>>>> various
> >>>>>>>>>>> fields to order a printing job from the In-Plant Print Shop. My
> >>>>>>>>>>> hope
> >>>>>>>>>>> is
> >>>>>>>>>>> to
> >>>>>>>>>>> have departments fill out the form and click the Submit button at
> >>>>>>>>>>> the
> >>>>>>>>>>> bottom
> >>>>>>>>>>> of the completed form and have it emailed back to me as an
> >>>>>>>>>>> attached
> >>>>>>>>>>> completed
> >>>>>>>>>>> form. I have designed this type of form before, but it has been
> >>>>>>>>>>> a
> >>>>>>>>>>> long
> >>>>>>>>>>> time.
> >>>>>>>>>>> I am trying to code the "Submit" button but am having problems.
> >>>>>>>>>>> I
> >>>>>>>>>>> have
> >>>>>>>>>>> copied and pasted the code from the previous form and made the
> >>>>>>>>>>> changes
> >>>>>>>>>>> in
> >>>>>>>>>>> the
> >>>>>>>>>>> form name. When I run the debug I get this error....User-defined
> >>>>>>>>>>> type
> >>>>>>>>>>> not
> >>>>>>>>>>> defined. The line of code that it highlighted is the "Dim
> >>>>>>>>>>> oOutlookApp
> >>>>>>>>>>> As
> >>>>>>>>>>> Outlook.Application".
> >>>>>>>>>>>
> >>>>>>>>>>> Can anyone help me figure this one out. Thank you in advance for
> >>>>>>>>>>> your
> >>>>>>>>>>> input.
> >>>>>>>>>>>
> >>>>>>>>>>> mptc
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >>>>
> >>>>
> >>
> >> --
> >> Russ
> >>
> >> drsmN0SPAMikleAThotmailD0Tcom.INVALID
> >>
> >>
>
> --
> Russ
>
> drsmN0SPAMikleAThotmailD0Tcom.INVALID
>
>