Hi everyone – hopefully you can help with this. I've successfully imported emails from an Outlook folder by creating an instance of Outlook in my VBA code, working through the mail items in a specified folder and building a string for each item. I need the "real" email address of the person sending the email and found out that by building a string including strSQL = "From: " & .SenderName gave me what I wanted.
However, I now need to do the same for emails sent in reply. I'm looking at the "Sent Items" folder but, and it's a big but, the .To fieldname is not giving me the "real" email address. It says "RayFrew" instead of rayfrew@gmail.com. I tried using the .Recipients fieldname but that gave an error.
Has anyone any pointer on this?
Many thanks
Ray
Posted by: rayfrew@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar