+ Reply to Thread
Results 1 to 2 of 2

Code to Email Specific People Based on ComboBox Selection

  1. #1
    Registered User
    Join Date
    02-17-2015
    Location
    Waco, TX
    MS-Off Ver
    2010
    Posts
    5

    Code to Email Specific People Based on ComboBox Selection

    Hello. When I introduced myself in this forum, I mentioned that I am an amateur. This code shows why I said that.

    The code allows me to select a person from a combobox and then press one of several buttons listed below:
    1. Save as PDF
    2. Save All as PDF
    3. Send PDF to the person
    4. Send PDF to the persons manager
    5. Send PDF to both people
    6. Send all people their individual PDF
    7. Send all people and their managers their PDF

    I got this all to work, but I know that the way I coded it will be hard to maintain. Can anybody suggest a better way?

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    02-17-2015
    Location
    Waco, TX
    MS-Off Ver
    2010
    Posts
    5

    Re: Code to Email Specific People Based on ComboBox Selection

    I had to split it up.
    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. VBA code to send email to the people whose email address is in the Access table
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2014, 05:11 AM
  2. Add information to specific Sheet based on ComboBox selection
    By paralegal91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 04:09 AM
  3. [SOLVED] Save and Send Userform data to a specific email address based on Combobox value
    By GMU in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2013, 01:13 PM
  4. [SOLVED] code for updating rows based on a userform combobox selection
    By raluk_ro22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2013, 11:09 AM
  5. based on selection in a combobox I need the corespoding value in a specific cell
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2009, 02:49 AM

Tags for this Thread

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