Results 1 to 7 of 7
  1. #1
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: use 'form' in sent.items (Outlook 98, )

    Did you mean to post that password? (You can edit using the <IMG SRC=http://www.wopr.com/w3timages/edit.gif> button above your post.)

    Do not try to post an .OST file.

    Is there a VBScript behind the form that needs to change the To field? Although this could trigger a security alert, it's not hard to do.

    If this doesn't help, perhaps you can rephrase the question.

  2. #2
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    use 'form' in sent.items (Outlook 98, )

    <P ID="edit" class=small>(Edited by gwhitfield on 20-Nov-03 22:02. A specific password was irrelevant to this post)</P>I have some forms that our users use to fill out and send to us so we can convert their data. What we do is take the attached files in the message (Outlook 98) field and extract the files and save them to a working directory. After we read the form to see what they want done to the data. - we take the attached file and use Data Junction to convert it to a Asscii Flat file or something. Now, the users have from 1 to 50 different files each day to process. So they look for a way to reuse the form with out having to fill it out again. The user will want to resubmit the form (because it is already filled out. SO they go to the Sent.Items and open the form and try to change the Attachments field at the bottom.

    My problem is when our users want to reuse the form that is already filled out in the sent.items folder. They change some of the fields to differnt setting, maybe a different input and out file. Will when they go to the message field to change the file that already attached it won't do it. But, in testing it by hand.. If I say forward the form and then attache the files it seems to work.

    Right now, I have it set up so it looks at the UserID and if the name on it is the same as the new userID, it will ask if this is a resubmit. If they reply Yes, How can I tell the form using VB to Forward the form to the "Control" email group? So I can then attache files to the Message field? If this is a little confusing I can attach the Outlook.ost file later.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: use 'form' in sent.items (Outlook 98, )

    I did think about posting the ost file. But I attached the vb script behind the form and on the doc - page 3 ln6 is where I ask if this is a resubmit form. If the answer is Yes - Y I wanted to see if I could get the form to accpet a different file in the message body. I think I need to make it a Forward function instead of a reply. Would something like this work? The newpassword is Marion90
    Function Item_Forward
    If Item.xxxx = reply Then
    Item_forward = true
    End function

    and where would it go?

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: use 'form' in sent.items (Outlook 98, )

    The Function Item_Forward would be called if the user forwarded the message. Is that the correct scenario? If so, then I don't understand the second line of your code. What does reply have to do with anything? Rather than do something relating to replies on a forward, just go ahead and ask whether the attachment should remain the same or be replaced. With that information, you then can code the necessary action. Something like this?

    If MsgBox("Change the attachment?", vbQuestion+vbYesNo) = vbYes then
    ' Remove all existing attachments
    While Item.Attachments.Count > 0
    Item.Attachments.Remove 1
    Wend
    ' Add new attachments
    Item.Attachments.Add "c:text.txt"
    End If

  5. #5
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: use 'form' in sent.items (Outlook 98, )

    If the reply was "no" that you did not want to resubmit it would not give you a new number, the form was displayed with the same number. This was done so people could call up the old document and print it or make changes to it and move or save it in a special folder for prof to show how the job was processed.

    Please keep in mine that I have had only 1 class VB Intro about 7 months ago so I'm not sure if I am doing a lot of things correctly. If I wanted to keep the code the way it was, where could I add the change?

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: use 'form' in sent.items (Outlook 98, )

    And keep in mind that I never use Outlook forms. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    I think you would insert the attachment stripping and adding code after you determine that it is a new submission, whever you are asking the question in your existing code.

  7. #7
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: use 'form' in sent.items (Outlook 98, )

    Just tried this and it works for what I need. Thanks everybody.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •