Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Outlook/VBA/Forms

Posted on 2004-08-31
7
407 Views
Last Modified: 2010-04-08
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
Comment
Question by:DeYoungJD
  • 3
  • 2
  • 2
7 Comments
 

Author Comment

by:DeYoungJD
ID: 11943758
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
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 11944715
What sort of database are you using to store the email addresses in?
0
 

Author Comment

by:DeYoungJD
ID: 11944727
Microsoft SQL Server.  I'm using a ADODB connection and querying based on SenderEmail.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 15

Expert Comment

by:will_scarlet7
ID: 11944940
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
 
LVL 5

Accepted Solution

by:
scottman29 earned 250 total points
ID: 11945025
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
 

Author Comment

by:DeYoungJD
ID: 11945383
Truly!  Rock on.  For some reason, i didn't even bother to check there.  Thanks - JD
0
 
LVL 5

Expert Comment

by:scottman29
ID: 11945881
Go me!!! :) good luck!
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read this checklist to learn more about the 15 things you should never include in an email signature.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question