+ Reply to Thread
Results 1 to 7 of 7

VBA Code to prompt while sending msgs from Outlook

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    VBA Code to prompt while sending msgs from Outlook

    Hi,

    Can anyone help me in getting the VBA Code to prompt while sending msgs from Outlook.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: VBA Code to prompt while sending msgs from Outlook

    There is an example here http://www.slipstick.com/outlook/ema...blank-subject/

    Please Login or Register  to view this content.
    To mark "Solved" go to Thread Tools.

  3. #3
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: VBA Code to prompt while sending msgs from Outlook

    Hello,

    Thanks for your help. Here my requiremnet is for each and every message which is going from outlook it should prompt the password and it has to go only after entering the password. can this be done?

  4. #4
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: VBA Code to prompt while sending msgs from Outlook

    In the ThisOutlookSession module.

    Option Explicit

    Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)

    Dim strPrompt As String
    Dim strInput As String

    strPrompt = "Enter password to send the Mail."
    strInput = InputBox(prompt:=strPrompt)

    If strInput <> "Password" Then Cancel = True

    End Sub

  5. #5
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: VBA Code to prompt while sending msgs from Outlook

    Thanks a lot Skatonni. Its working superbly. But, while entering password some one can see this...Is it possible to show **** sign?

  6. #6
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: VBA Code to prompt while sending msgs from Outlook

    In Excel yes https://support.microsoft.com/en-us/kb/830258

    In Outlook you can try font colour the same as background colour.

    Create a userform named Password_Hidden.

    Add a textbox.
    Set font colour the same as background colour in the textbox.

    Add a command button. Double click to add this code
    Please Login or Register  to view this content.
    In ThisOutlookSession
    Please Login or Register  to view this content.
    In a regular module
    Please Login or Register  to view this content.

  7. #7
    Spammer
    Join Date
    10-23-2015
    Location
    London
    MS-Off Ver
    nokia
    Posts
    1

    Re: VBA Code to prompt while sending msgs from Outlook

    thanks you for sharing give people

+ 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. Sending Workbook via Outlook but with Release Manager in Outlook
    By Jim28 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2014, 12:12 PM
  2. Code for sending Outlook 2003 mail based on a mailing list in Excel 2003
    By Rambo4711 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2013, 06:03 AM
  3. Conversion of macro code for sending mails from outlook to lotus notes
    By praveen2825 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 08:48 AM
  4. Sending screenshot via outlook using excel code
    By ge0rge in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-07-2012, 05:23 AM
  5. VBA code sending Outlook e-mail
    By dkub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2011, 06:30 PM
  6. Automate: Export Outlook Msgs
    By whamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2006, 06:43 AM
  7. [SOLVED] How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2005, 05:06 PM

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