Results 1 to 10 of 23

Thread: how to send each row by email

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    HI

    like

    Code:
    .Subject = Range("C" & i).Value & ", Expired account notification"
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Junior Member
    Join Date
    Aug 2012
    Posts
    14
    Rep Power
    0
    Thanks to both of you Gentlemen.
    I have checked the second one only and works smoothly.

    Quote Originally Posted by Excel Fox View Post
    Code:
    .Subject = varBody(1, 3) & ", Expired account notification"
    Quote Originally Posted by Admin View Post
    HI

    like

    Code:
    .Subject = Range("C" & i).Value & ", Expired account notification"
    Thanks
    Baris

Similar Threads

  1. Replies: 17
    Last Post: 07-15-2013, 09:56 PM
  2. Replies: 2
    Last Post: 05-23-2013, 08:08 AM
  3. How To Send Outlook Email Using VBA
    By mfaisalrazzak in forum Excel Help
    Replies: 7
    Last Post: 03-03-2013, 03:09 AM
  4. Send Outlook Email With Word Document
    By Murali K in forum Excel Help
    Replies: 2
    Last Post: 06-27-2012, 08:42 PM
  5. Send Lotus Notes Email Using VBA
    By ramakrishnan in forum Excel Help
    Replies: 1
    Last Post: 09-08-2011, 09:00 AM

Posting Permissions

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