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

    Outform TO address (MS Outlook 2003 VBA)

    I use the following to forward a form after I have filled in all the data fields. MY problem...? Instead of forwarding the form as is. I want it to come back ask for the TO: address. After I change it or enter a name I want to forward it.

    '-=-=-=-=-=-=-=-
    Sub Forward5
    Item.To = "Tabs Impact Team"
    Item.SentOnBehalfOfName = strCAD
    Item.Send
    End sub
    '-=-=-=-=-=-=-=-=-=-

    Its simple but it has worked for me upto this change.

  2. #2
    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: Outform TO address (MS Outlook 2003 VBA)

    I'm not sure I understand your question. You want your code to work more like the following?

    Sub Forward5
    Item.To = Collect input from user
    Item.Send
    End sub

    You have several options, including using InputBox, building your own UserForm...

Posting Permissions

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