Results 1 to 3 of 3

Thread: Send emails with worksheet attachment to multiple email addresses

  1. #1
    Junior Member
    Join Date
    Aug 2016
    Posts
    2
    Rep Power
    0

    Send emails with worksheet attachment to multiple email addresses

    I have worked out how to send an email from excel to a single person (with a specified email address stated in the VBA code). However, as I am creating a form which will require it to be sent to multiple email address (which can't be specified, as the required email addresses will vary). Therefore, if the user of the form was to put the email address in certain cells on the form ie. B20, B13 etc. then how could I make sure that the address entered in to the cells - will be the email address that the worksheet will be sent to. I don't need a macro to include subject lines or messages etc. just the worksheet to be emailed to them. The macro is in a 'submit' button, which I've already created - I just need to edit the VBA code.

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgxesLhWNr_zNP0GUdh4AaABAg. 9hI1CQJMLLo9hWn2pGBeSS
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgzkRujoMw9PblmXDQ14AaABAg. 9hJRnEjxQrd9hJoCjomNI2
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgzPZbG7OvUkh35nXDd4AaABAg. 9hJOZEEZa6p9hJqLC7El-w
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgwUcEpm8u6ZW3uOHXx4AaABAg. 9hIlxxGY7t49hJsB2PWxC4
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgyvDj6NWT1Gxyy2JyR4AaABAg. 9hIKlNPeqDn9hJskm92np6
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=Ugwy7qx_kG9iUmMVO_F4AaABAg. 9hI2IGUdmTW9hJuyaQawqx
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgxesLhWNr_zNP0GUdh4AaABAg. 9hI1CQJMLLo9hJwTB9Jlob
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgyyQWYVP1OnCqavb-x4AaABAg
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgwJKKmExZ1FdZVDJf54AaABAg
    https://www.youtube.com/watch?v=pkhazgI3LAo&lc=Ugz_p0kVGrLntPtYzCt4AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9iHOYYpaAbC
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgxuL6YCUckeUIh9hoh4AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg. 9h4sd6Vs4qE9h7G-bVm8_-
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 09-22-2023 at 05:02 PM.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    eMorgan, welcome to ExcelFox

    Do you want to send individual emails or can the same mail be sent with multiple recipients
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Aug 2016
    Posts
    2
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    eMorgan, welcome to ExcelFox

    Do you want to send individual emails or can the same mail be sent with multiple recipients
    The same mail can be sent to multiple recipients, but the other recipients would need to be 'CC' in.

Similar Threads

  1. Replies: 12
    Last Post: 12-10-2019, 09:56 PM
  2. Replies: 3
    Last Post: 02-09-2019, 08:44 AM
  3. Replies: 0
    Last Post: 08-04-2015, 11:08 PM
  4. Replies: 0
    Last Post: 01-16-2014, 09:20 PM
  5. Replies: 6
    Last Post: 06-05-2013, 11:33 PM

Posting Permissions

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