+ Reply to Thread
Results 1 to 2 of 2

excel cell info extracted to outlook subject line as dragged in or added

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Canada
    MS-Off Ver
    ms365
    Posts
    79

    excel cell info extracted to outlook subject line as dragged in or added

    Hello,

    Is there a VBA way so when an excel file is attached (or dragged in) to the outlook email as an attachment, the excel file's cell info shows up as the subject line of the email?

    Please see attached for visuals. Thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: excel cell info extracted to outlook subject line as dragged in or added

    If it's possible (I am not sure it is) it would be complicated and have to be done in Outlook VBA.

    What you can do instead is have code in Excel to create the email, attach the file, and set the subject line based on the cell. I'm not going to dive into that unless you tell me that would be helpful.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Foreign language or symbols in Outlook subject line when mailed using macro in Excel
    By go3go3go in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2020, 11:26 AM
  2. Autofill outlook subject line from excel sheet
    By Dancon in forum Outlook Formatting & Functions
    Replies: 9
    Last Post: 04-27-2020, 03:22 AM
  3. Autofill outlook subject line from excel sheet
    By Dancon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2020, 06:26 PM
  4. VBA Code - Extracting Outlook Subject line text into various Excel columns
    By MHamid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2017, 12:24 PM
  5. Replies: 0
    Last Post: 06-18-2015, 05:35 PM
  6. Replies: 8
    Last Post: 05-17-2013, 01:53 AM
  7. Outlook Subject line from Excel Cell reference
    By Shibu.excel in forum Outlook Formatting & Functions
    Replies: 4
    Last Post: 09-06-2012, 03:19 AM

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