+ Reply to Thread
Results 1 to 2 of 2

Use a drop down list to send a different email based on selection

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Use a drop down list to send a different email based on selection

    I'm currently using a sheet change event to trigger a macro to that uses a word doc as an email body sent via outlook, this works flawlessly. I understand that it is possible to have only one sheet change event per sheet. Therefore I'm limited to a single doc selection.

    Is it possible to achieve the same outcome but to have a macro select and use a different word doc depending on the selection of a drop down list ?

    Any help you can provide would be great, thanks.
    Last edited by sipa; 08-01-2016 at 04:27 AM.

  2. #2
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Re: Use a drop down list to send a different email based on selection

    OK, Solved It.

    I've just added "Else" to the sheet change event. This will cycle through the options in the drop down list until it finds a match then load the appropriate macro to load and fire off the correct email for the option in the drop down list.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  2. Replies: 4
    Last Post: 01-30-2016, 02:13 PM
  3. send email through Lotus Notes, with attachment, based on exce list address and path
    By ABDULLAHHATMI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2013, 11:11 AM
  4. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  5. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  6. Email spreadsheet based on drop down selection
    By cabinetguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2011, 09:53 AM
  7. Drop down list disappears when spreadsheet is send via email
    By dwarford101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2010, 06:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1