Launch Email with a dropdown List

**John Fletcher** · 10-30-2007, 09:21 PM

Hi,

Another question?

Is it possible to Launch individual Email addresses for names in a dropdown List?

John

**Leith Ross** · 10-30-2007, 09:41 PM

Hello John,

Yes you can. Where are the addresses located? Are they hyperlinks or test?

Sincerely,
Leith Ross

**John Fletcher** · 10-30-2007, 10:04 PM

Names in a dropdown list - I would like it so that when a person selects the name not only doew it select the person assigned to work the file but sends an email to the selected person..... This list is set far, far to the right out of view and the dropdowns function in Column L

Andrea
Antionette
Betty
Carlos
Chary
Cheryl
David E
David L
Dennis
Donna
Erin
Faith
John
Johnny
Lynda
Maria
Matthew
Nicole
Pamela
Rachell
Sonia
Stacy
Stephanie

**John Fletcher** · 10-30-2007, 10:05 PM

Text...

THanks,

John

**Leith Ross** · 10-30-2007, 10:07 PM

Hello John,

Are the email addresses in an address book or listed in another column on the worksheet?

Sincerely,
Leith Ross

**John Fletcher** · 10-30-2007, 10:20 PM

The email addresses can be alongside the names featured previously if needed - will this help?

**Leith Ross** · 10-30-2007, 10:26 PM

Hello John,

That makes it easy to associate the name to the proper email address. I'll post back in while with the code.

Thanks,
Leith Ross

**John Fletcher** · 10-30-2007, 10:31 PM

Wow, you are incredible.... Thanks

**John Fletcher** · 10-30-2007, 11:20 PM

Hello Leith,

How is it going with the code?

Anything I can do to assist?

John

**Leith Ross** · 10-30-2007, 11:59 PM

Hello John,

We had a little excitement out here in California just a little while ago in the form of an temblor (small quake). So, everyone has been calling etc. So now I hope to get back on track with you.

Sincerely,
Leith Ross

**John Fletcher** · 10-31-2007, 12:10 AM

Hello Leith,

Cool - Everything OK?

Born and raised in Santa Clara Ca - Know all about those tremors - Now in Arizona - Phoenix!

Anything I can do to help with the code?

John

**John Fletcher** · 10-31-2007, 07:42 AM

Hi,

Is it possible to Launch individual Email addresses for names in a dropdown List?

Names in a dropdown list - I would like it so that when a person selects the name not only doew it select the person assigned to work the file but sends an email to the selected person..... This list is set far, far to the right out of view and the dropdowns function in Column L

Next to the list of Names in Column M is a list of the email addresses...

Andrea
Antionette
Betty
Carlos
Chary
Cheryl
David E
David L
Dennis
Donna
Erin
Faith
John
Johnny
Lynda
Maria
Matthew
Nicole
Pamela
Rachell
Sonia
Stacy
Stephanie

Thanks,

John

**VBA Noob** · 10-31-2007, 07:46 AM

Please don't post duplicate questions.

See if you adapt this link to your needs

http://www.rondebruin.nl/mail/folder1/mail5.htm

or try the add-in

VBA Noob

**John Fletcher** · 10-31-2007, 07:50 AM

Thanks for your reply... This will not provide the soulution... As far as duplicate posts.... My origional post, I was talking with Leith and he had an Earth Quake... assuming things got busy, was not able to assist..

Nontheless, never did finish... this was 6 hours ago... thought I would try again before I went to the office...

John

**VBA Noob** · 10-31-2007, 07:56 AM

Why won't it work. Did you install the add-in

If you reply to the original thread someone may have picked up on it

VBA Noob

**John Fletcher** · 10-31-2007, 08:02 AM

This reference and source you mention provides for the sending of the entire spreadsheet... the needs that I have is to simply select from a dropdown list and launch the email (Outlook) to send an email to the person selected...

I have made a dropdown list with the email address of the people ... yet I want to somehow use just the names of the people without the actual email address being visable...

after speaking with Leith earlier, It appreared as though it may be possible....This may not be possible.... ????

John

**John Fletcher** · 10-31-2007, 08:05 AM

This reference and source you mention provides for the sending of the entire spreadsheet... the needs that I have is to simply select from a dropdown list and launch the email (Outlook) to send an email to the person selected...

I have made a dropdown list with the email address of the people ... yet I want to somehow use just the names of the people without the actual email address being visable...

after speaking with Leith earlier, It appreared as though it may be possible....This may not be possible.... ????

John