+ Reply to Thread
Results 1 to 2 of 2

Send Email By Vba

Hybrid View

Leonardo1234 Send Email By Vba 07-01-2023, 06:58 AM
davesexcel Re: Send Email By Vba 07-01-2023, 07:14 AM
  1. #1
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Send Email By Vba

    Hi,
    I need a Help Reg Send Mail by VBA

    I am looking for a code that will do the below things
    It will send the mail to abc@gmail.com
    It will send the mail from abc1@gmail.com
    In the Subject of the Mail will be abc 123
    Inside the mail there will be Hi Avinash

    Thnx For the Help

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Send Email By Vba

    Sub GenericEmail()
     Dim sPDF As String
    
     
     With CreateObject("outlook.application").createitem(0)
       .to = "someone@somewhere.com"
       .Subject = "Here it is"
       .body = "There it was"
    
       .display
       '.send
     End With
    End Sub

+ 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. [SOLVED] send email, does not send correct email
    By incobart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2023, 12:09 AM
  2. Excel to send email to two addresses in two cells? MSG box upon send?
    By sdyer02 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2016, 08:22 PM
  3. I send email using Lotus from Excel but how to send from Thunderbird?
    By EvelynLoh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2015, 11:31 PM
  4. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  5. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM
  6. Automatic send email (without even click send in mail software) with excel vba ??
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2013, 08:31 PM
  7. Code to send Email wont send everytime
    By tanktata in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-11-2011, 04:44 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1