Results 1 to 10 of 13

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-01-2013, 10:17 PM #4
    bandus
    bandus is offline
    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?

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=316254#p316254
    https://eileenslounge.com/viewtopic.php?p=316280#p316280
    https://eileenslounge.com/viewtopic.php?p=315915#p315915
    https://eileenslounge.com/viewtopic.php?p=315512#p315512
    https://eileenslounge.com/viewtopic.php?p=315744#p315744
    https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
    https://eileenslounge.com/viewtopic.php?p=315680#p315680
    https://eileenslounge.com/viewtopic.php?p=315743#p315743
    https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
    https://eileenslounge.com/viewtopic.php?p=314950#p314950
    https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
    https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
    https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
    https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 04-16-2024 at 01:03 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Send Bulk Personalized E-Mail Through Outlook Using VBA
    By partho in forum Excel Help
    Replies: 5
    Last Post: 06-11-2013, 08:15 PM
  2. VBS Code to Pull Email SMTP Address From Outlook And Send Email
    By cdurfey in forum Excel Help
    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. Excel and Outlook Integration For email sending with signature file
    By Data_Analyst in forum Excel Help
    Replies: 3
    Last Post: 02-20-2012, 12:54 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
  •  

Forum Rules