Send Workbook to Email & Include Table values within Email Subject

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

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?

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)