Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Other Office > Word VBA
Word VBA Discuss using VBA to program Word.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Word VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 14th, 2008, 10:23 AM
Registered User
Join Date: Mar 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to John_Galt
Default Help creating a combo-box for emailing URLs

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: arowland@apbspeakers.com
Web: www.apbspeakers.com

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo box to display items from parent combo box Gini Visual Studio 2008 0 June 18th, 2008 12:30 AM
Count in combo box(display results in text box) mboyisis Access 4 April 4th, 2008 07:08 AM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
Help needed on creating User Friendly URLs minalarora ASP.NET 2.0 Professional 1 May 7th, 2007 07:19 PM
Creating custom Combo box control nazran VB How-To 2 January 21st, 2004 02:30 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.