+ Reply to Thread
Results 1 to 2 of 2

Add additional attachments to email if Check box checked

  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    49

    Add additional attachments to email if Check box checked

    Hi,
    Tried searching but couldn’t find anything that helped.
    I have inherited a macro that sends the active sheet as an attachment to a recipient (based on a pull down) via email.
    I want to include additional attachments if a checkbox is checked (Linked to cell CA29).
    The code below works, as in when you select the send button it sends the sheet to email as an attachment but the issue I’m having is,
    The selection window pops up for you to select a file to attach whether or not you have the check box checked or not.

    This is the section I added for additional attacents.
    Please Login or Register  to view this content.
    Can someone help please.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    04-15-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    49

    Re: Add additional attachments to email if Check box checked

    I have solved this myself with the code below thanks for all those who tried.
    Putting this up in case anyone else needs it.

    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. How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 04:36 PM
  2. Check Box that shows options in Combo Box if Checked, and Hides if Not Checked
    By dumbjodie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2013, 10:06 AM
  3. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:56 PM
  4. Replies: 0
    Last Post: 02-21-2013, 04:46 AM
  5. Replies: 2
    Last Post: 12-19-2012, 11:23 PM
  6. Add additional attachments to email VBA application
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2010, 12:22 PM
  7. Print when check box checked
    By vincenealon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 08:41 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