convert mbox to csv

It was intended to be "step 1". I was thinking there might be a pattern to the madness that would allow you to extract the information you want using formulas.

Have you asked in whatever forum covers Apple Mail? Maybe someone there will have a better answer.

What did you do in Outlook? I ask out of curiosity.

It seems that what you are asking for could be scripted with AppleScript. I don't know enough to do it but it sure looks possible.

No, I think I was late to the party posting the script. I do not understand what the solution actually was.

Ahh. Same OP. I get it now. That threw me off.

I'm keeping your thread around for the next time a similar question comes up.

SGIII just posted a script in another thread that exports selected emails to a Numbers table. You might try it on one of your emails to see if the content ends up in a cell in a format that you can use. If so, maybe you can make some adjustments to the script for your needs.

set dataLst to {{"SenderAddress", "SenderName", "Date", "Time", "Content"}}

tell application "Mail"
	repeat with aMsg in items of (get selection)
		tell aMsg
			set senderNameAddr to my splitEmail(sender)
			set senderAddr to item 2 of senderNameAddr
			set senderName to item 1 of senderNameAddr
			set msgSubj to subject
			set msgDate to date received
			set msgTime to time string of msgDate
			set msgDate to my dateFormat(date string of msgDate)
			set msgContent to content
			set msgLst to {senderAddr, senderName, msgDate, msgTime, msgContent}
			copy msgLst to dataLst's end
		end tell
	end repeatend tell

tell application "Numbers"
	set newDoc to make new document
	tell table 1 of active sheet of newDoc
		delete column "A" -- remove default Header Column
		set column count to length of item 1 of dataLst
		set row count to (length of dataLst)
		repeat with i from 1 to length of dataLst
			repeat with j from 1 to length of item 1 of dataLst
				set value of cell j of row i to item j of item i of dataLst
			end repeat
		end repeat
	end tellend tell

to dateFormat(aDateString) --> yyyy-mm-dd
	set {year:y, month:m, day:d} to date aDateString
	tell (y * 10000 + m * 100 + d) as string to text 1 thru 4 & "-" & text 5 thru 6 & "-" & text 7 thru 8end dateFormat

to splitEmail(nameAddress)
	set text item delimiters to "<"
	tell nameAddress
		set theName to text item 1
		set theAddress to text 1 thru -2 of text item 2
	end tell	return {theName, theAddress}
end splitEmail

Badunit wrote:

SGIII just posted a script in another thread that exports selected emails to a Numbers table.

The other thread is here. Same OP.

https://discussions.apple.com/thread/253056753

The script seems to have "solved" the problem, though that's not clear.

SG