Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

Outlook/VBA/Forms

Hello - I am writing a VBA application that once an email is received, it will sort it into a specific folder based on the sender's email address.  At this moment, it works great, however each time I get a new person emailing me, I have to manually enter the email address into the database which takes to long.  I am looking for a way to create a simple popup window/form that I can design that can capture a users' selection and enter it into the database.  The problem I'm having that I can't seam to find a way to design a form in VBA for outlook 2003.  

I'm sure this is a very easy question to answer but at this point, i don't see a solution.

Help is greatly appreciated.
0
DeYoungJD
Asked:
DeYoungJD
  • 3
  • 2
  • 2
1 Solution
 
DeYoungJDAuthor Commented:
Just to make it a little more clear...I want to create a custom form that has three fields...the users' email address, a box for the users name and the third field is a list of folders in a drop down format most likely.  So, two text boxes and one drop with a submit button that is linked to a capture action function.

Thanks - JD
0
 
will_scarlet7Commented:
What sort of database are you using to store the email addresses in?
0
 
DeYoungJDAuthor Commented:
Microsoft SQL Server.  I'm using a ADODB connection and querying based on SenderEmail.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
will_scarlet7Commented:
You might be able to create a Custom outlook form and your code opens it and then reads the value back out.. The only other way I can think of for doing what you want would be to use 2 Input boxes and a FolderPicker.
0
 
scottman29Commented:
Why couldn't you go into outlook, goto tools-->macro-->visual basic editor, then from there insert a user form, and add your input boxes to it.  You would then set the critera to open the form.

this is a very simple answer, but it sounds like you know how to program it, you just needed where to go.

HTH,
Scott
0
 
DeYoungJDAuthor Commented:
Truly!  Rock on.  For some reason, i didn't even bother to check there.  Thanks - JD
0
 
scottman29Commented:
Go me!!! :) good luck!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now