• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Mail in_reply_to field is Null in Envelope Index
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Mail in_reply_to field is Null in Envelope Index


  • Subject: Mail in_reply_to field is Null in Envelope Index
  • From: John <email@hidden>
  • Date: Mon, 28 Oct 2013 20:39:32 -0400

I am trying to pull some data from the sqlite database Mail uses. However, the in_reply_to field of the messages table is NULL for every value when it should return the message id of the original message which was replied to.
set databasePath to POSIX path of (path to library folder from user domain as text) & "Mail/V2/MailData/Envelope Index"
set theReply to (do shell script "sqlite3 " & quoted form of databasePath & " \"SELECT DISTINCT in_reply_to from messages;\"")
However, I can extract the value of the header with something like this:

tell application "Mail"
          set aMessage to first item of (get selection)
          try
                    set inReplyTo to extract address from (content of aMessage's header "in-reply-to")
          on error
                    set inReplyTo to "NULL"
          end try
end tell
Where can I find the value of in_reply_to field within the Envelope Index database?
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

  • Follow-Ups:
    • Re: Mail in_reply_to field is Null in Envelope Index
      • From: Axel Luttgens <email@hidden>
    • Re: Mail in_reply_to field is Null in Envelope Index
      • From: Bruce Brown <email@hidden>
  • Prev by Date: Re: ASEditor Drag&Drop
  • Next by Date: Re: ASEditor Drag&Drop
  • Previous by thread: Re: Property List Editore (was: AppleScript-Users Digest, Vol 10, Issue 357)
  • Next by thread: Re: Mail in_reply_to field is Null in Envelope Index
  • Index(es):
    • Date
    • Thread