Results 1 to 3 of 3

Thread: Send Workbook to Email & Include Table values within Email Subject

  1. #1
    Acolyte jilbobagins's Avatar
    Join Date
    Apr 2019
    Posts
    49
    Articles
    0
    Excel Version
    2016

    Send Workbook to Email & Include Table values within Email Subject



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hoping someone can assist once again!!

    I have a workbook/form that records changes applied to vehicles (in this example). I would like to be able to create some code to enable send the workbook to a specific email address and then include within the Email subject the Vehicle_Change. As can be seen in the example workbook and snapshot of the email the Subject Heading would be : HD53YUF_CR123456,C654321,134625.

    Any assistance would be greatly appreciated!!

    Cheers
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture4.JPG 
Views:	16 
Size:	54.3 KB 
ID:	9349  
    Attached Files Attached Files

  2. #2
    Conjurer Kenneth Hobson's Avatar
    Join Date
    Mar 2014
    Location
    Tecumseh, OK
    Posts
    136
    Articles
    0
    Excel Version
    365
    You are emailing the whole workbook? Rod de Bruin has examples here. https://www.rondebruin.nl/win/s1/outlook/mail.htm

    It looks like you used a vehicle_change1,change2, etc. for the subject line. Is it always the case where the workbook only has one vehicle?

  3. #3
    Acolyte jilbobagins's Avatar
    Join Date
    Apr 2019
    Posts
    49
    Articles
    0
    Excel Version
    2016
    Hi and thanks for responding (i'll take a look at the link!)

    Yes the whole workbook, and currently yes only one vehicle per workbook (however that might change eventually)

Posting Permissions

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