Results 1 to 5 of 5

Thread: Choose A Salutation Based On Time Using VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    15
    Hi ALan,

    Plz find the workbook for your reference to insert salutation based on time (mail sent)

    Also I would like to point out two more issue am facing with this macro.
    I am using this macro to send the sheets(not workbook) as attachment to the specified mail id the VBA code.

    if the mentioned sheet not available in the workbook then macro gets stopped. Kindly help amend the VBA code as if the specified sheet is not available then it should move to the next command.

    Also I want to change the font, size and colour in the body of the email.(I preferred to send courier new with font size 11)

    Kindly do the needful.
    Prabhu
    Attached Files Attached Files

Similar Threads

  1. How To Change Date Based On Time Using Formula
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-03-2013, 11:03 PM
  2. Replies: 5
    Last Post: 05-28-2013, 03:00 AM
  3. Replies: 2
    Last Post: 04-16-2013, 01:36 PM
  4. Choose from several sheets
    By marreco in forum Excel Help
    Replies: 3
    Last Post: 08-29-2012, 02:46 AM
  5. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 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
  •