+ Reply to Thread
Results 1 to 5 of 5

Value of a cell for email subject line

  1. #1
    Registered User
    Join Date
    09-26-2008
    Location
    NEPA
    Posts
    5

    Value of a cell for email subject line

    OK I got another deally I'm stuck with, Ill explain what I want to do.

    I would like to select File/Send to/Main Recipient (As Attachment) within my Excel Spreadsheet. Within the email, I would like the subject line to be automatically filled in with an entered value of a cell block from within the spreadsheet.

    For Example, If cell block A1 had Thursday entered in the cell. Then once I chose send to/Mail Recipient, The subject line would read Thursday.

    Is this possible? And if it is, any ideas?

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Put this into a macro and run it any way you want. Edit for your preferences:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-26-2008
    Location
    NEPA
    Posts
    5
    Ok I made this subject string for my macro.

    I have one more problem I need help with
    this is the string I made

    Please Login or Register  to view this content.
    Everything is working. but the problem lies in Cells(7, 3) and Cells(7, 4) They are supposed to be time format, for example Cell(7, 3) reads "12:03 PM" But when I start the macro to send it to the subject line of the email it read, 2.08333333333333E-03,

    How do I change the format within the macro string I created???

    Any help would be highly appreciated!

    Thanks

    KC
    Last edited by VBA Noob; 11-28-2008 at 06:09 PM.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Not sure about the new syntax, but you can change the code I originally posted to refer to your STart and Stop dates in cells, the same as the subject line Publication.

    C3 --> Subject Line
    H3 --> Start date
    I3 --> Stop date
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-26-2008
    Location
    NEPA
    Posts
    5
    I got it, here is what I did
    Please Login or Register  to view this content.
    It may be sloppy, but it works.

    Thanks!!!
    Last edited by Leith Ross; 11-29-2008 at 01:07 PM. Reason: Added Code Tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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