Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Send Outlook Mail With Signature, Range From Excel and Multiple Email IDs

  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10

    Lightbulb Send Outlook Mail With Signature, Range From Excel and Multiple Email IDs

    This is an extension of an earlier post here in the forum where we talk about sending mails with attachments and also copying a defined range from the excel spreadsheet on to Outlook.

    The piece here is an upgrade to the one above.

    I have added the option to use signature in the mail, and also allowed flexibility to use more than one email id in the To, or CC or BCC section.
    Attached Files Attached Files
    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

  2. #2
    Junior Member
    Join Date
    Nov 2013
    Posts
    7
    Rep Power
    0
    Dear Excel Fox,
    Thanks for this awesome solution. However I cannot skip displaying my message, why is this happening?

    Ichanged the
    Code:
    blnShowEmailBodyWithoutSending
    variable to False and also deleted a .Display command from the Else section but it still pops up the window woth the message? How could I turn off this function?

    Thanks again in advance!

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Are you saying it is not sending the mail, but only displaying the message, or are you saying that it is showing the security suspicious activity message for accessing Outlook?
    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

  4. #4
    Junior Member
    Join Date
    Nov 2013
    Posts
    7
    Rep Power
    0
    In the previous version of this email-sender when I changed the "blnShowEmailBodyWithoutSending" variable there were two options: the macro sent the messages "automatically" or displayed the message and I had to click on the send button.

    Now either this variable is true or false the macro always pops up the message window and I have to send it manually in both cases. The code is the following:

    Code:
     'Should we display the message before sending?
            If blnShowEmailBodyWithoutSending Then
                .Display
            Else
                .Display
                .Save
                .Send
            End If
    So I thought the solution is changing the "blnShowEmailBodyWithoutSending" to False and delete the .Display command from the Else section, but it still shows the email before sending and I still have to click on send to send it. Do you have any idea why is this happening?

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Not sure why I kept the line like that, but it should be

    Code:
    'Should we display the message before sending?
            If blnShowEmailBodyWithoutSending Then
                .Display
            Else
                .Save
                .Send
            End If
    And blnShowEmailBodyWithoutSending should be FALSE
    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

  6. #6
    Junior Member
    Join Date
    Nov 2013
    Posts
    7
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Not sure why I kept the line like that, but it should be

    ...

    And blnShowEmailBodyWithoutSending should be FALSE
    Yes, this is exactly what I thought as a solution, but it still shows the message and I have to click on send manually. So in theory it should be working but unfortunately it is not. If you do these modification in your computer does it work? Just to know if something wrong with my system because the code semms completely correct for me.

    Thanks for investigating the problem!





    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-11-2023 at 03:33 PM.

  7. #7
    Junior Member
    Join Date
    Nov 2013
    Posts
    7
    Rep Power
    0
    I came up with a not so sophisticated solution:
    defined the variable as a boolean but not optional, and then gave the False value for it.

  8. #8
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    If that's working, then there has to be something easily correctable. I will look at it and post an update.

  9. #9
    Junior Member
    Join Date
    Nov 2013
    Posts
    7
    Rep Power
    0
    Hi Excel Fox,

    Another question came up for me: is it possible to somehow add pretty and formatted text to the body of a message using this macro or should I search for the solution somewhere else?

    Thank you in advance!

    bandus

  10. #10
    Junior Member
    Join Date
    May 2016
    Posts
    1
    Rep Power
    0

    Signature Issue

    Hi Excel Fox

    Thank you for a brilliant script, it is awesome.

    I am having an issue with the signature thought, I have images in my signature and it is not inserting them they are just showing up as image boxes with the image unavailable.

    I am using Outlook 2013.

Similar Threads

  1. Replies: 5
    Last Post: 06-11-2013, 08:15 PM
  2. Replies: 2
    Last Post: 05-23-2013, 08:08 AM
  3. Automatically send Birthday E-Mail in Outlook
    By s.ajay88 in forum Outlook Help
    Replies: 2
    Last Post: 03-12-2013, 06:28 PM
  4. Outlook Send Mail With Multiple Recipient and CC
    By noobtron in forum Excel Help
    Replies: 2
    Last Post: 10-31-2012, 07:14 PM
  5. Replies: 3
    Last Post: 02-20-2012, 12:54 AM

Tags for this Thread

Posting Permissions

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