FYI: I am a tech-savvy web dev but a newbie at programing.

Problem I am looking to solve:
My sales force sells via email, by making product recommendations and including the link to the respective product page on our site. With 1,300+ product pages that have no schema, I would like to create a form/macro in Outlook that will make the extremely inefficient (and repetitive) task of copy and pasting 5-30 links from a list into an email, more efficient.

Functionality I am looking for:
Within Outlook, I would like them to be able to view all of the product pages in a drop down that will allow them to choose the items they want to recommend, then have the script write them to the body of the email displaying anchor text with HTML links.

I would also like to eventually use an XML schema file (still working out the last bugs of a new taxonomy)to create a second (or more robust version of first) combo-box that would group the product pages according to the hierarchy defined in the schema.

I know I should be able to do this with VBA or VBscript and then push it out to all clients, but I am struggling with VBA(2005).
I initially tried to use a macro from Excel 07 using some code I found in a similar thread, but I think because I want to add this to everyone's client I will have to do it through Outlook.

Any help, insight or reference to external resource would be great!

Andrew Rowland
Marketing Coordinator
American Program Bureau, Inc.
313 Washington Street, Suite 225
Newton, MA 02458
Toll Free: 800-225-4575 x 1622
Direct: 617-614-1622
Fax: 617-965-6610
Email: [email protected]
Web: www.apbspeakers.com