DeYoungJD
asked on
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.
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.
What sort of database are you using to store the email addresses in?
ASKER
Microsoft SQL Server. I'm using a ADODB connection and querying based on SenderEmail.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Truly! Rock on. For some reason, i didn't even bother to check there. Thanks - JD
Go me!!! :) good luck!
ASKER
Thanks - JD