Solved

Outlook/VBA/Forms

Posted on 2004-08-31
7
408 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
[X]
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
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

735 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