Suggestions for photos sent by email

[twoj]

I'm sure someone has had this issue before me.
I want to take the photos that people have sent to me in emails, the typical group snaps that get sent to everyone's email, and load it into LightRoom but I would like to retain the email, or the content of the email as metadata in the photo.

Often the email contains information that is relevant to the photo so i would like to keep that with the photo and delete the original email, so i'm looking if someone has thoughs or a process of saving the email content in a metadata field that would be used by LR.
I don't think attaching a msg within the metadata would be practical since it would need to be extracted and read by a mail client, but something like saving the email as a text, html, or pdf and saving that in the metadata?
Also what field do you think it should go into so that it could be read by most viewers? The one that seems the best to me would be XMP:Description, but i don't know.

Thanks for suggestions and input!

[StarGeek]

Adding the plain text to the XMP:Description tag would probably be best.  HTML would be possible, but it would look like HTML.  It's not standard to view an image or video's metadata with a browser.  PDF would be unreadable, as it would have to be base64 encoded and would have to be extracted and decoded before it was viewed.

[Hubert]

Do you use Mail for macOS? If so, you can AppleScript the first bit (saving the mail attachment to a folder, writing the content of the email to xmp:description or the tag of your choice with ExifTool). I don't have Lightroom so I don't know how that end of things would work.