I should actually make my request more clear. I receive about 5 emails a day that are automatically moved to a folder called "- Changes" in outlook. I would like to create a code that searches the unread emails in this folder and have the body of the email placed into column B on a sheet called "Changes". The format of the emails is always the same. It is always a line of text, double space, another line of text. I would like each line of text to be on their own row rather than the entire body placed in one cell. Attached shows an example of what I am looking for.
Bookmarks