Embedding Outlook email in Excel
0
I will have a folder in Outlook with emails or perhaps a folder on the computer where the emails will be saved.
I need to loop through the folder and embed .msg files (including any attachments within the emails) to a tab in Excel. This is for audit purposes so that if someone goes into the Excel file they will be able to open the emails and view any attachments that were provided.
excel vba outlook
edited Nov 17 '18 at 5:06
Community♦
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
add a comment |
0
I will have a folder in Outlook with emails or perhaps a folder on the computer where the emails will be saved.
I need to loop through the folder and embed .msg files (including any attachments within the emails) to a tab in Excel. This is for audit purposes so that if someone goes into the Excel file they will be able to open the emails and view any attachments that were provided.
excel vba outlook
edited Nov 17 '18 at 5:06
Community♦
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
1
What do you mean by "add the emails to a tab in Excel"? Do you mean embedding the .msg file, transcribing the content to cells, adding a link to a location on your file system or something else entirely? In any case, the question's too broad to get a useful answer here.
– jsheeran
Nov 14 '18 at 9:40
Hi there, sorry. I didn't think the question was too broad but I see your point now I re-read it. yes it would be embedding the .msg file so that when someone goes back into the file they can always access the original emails that relate to the file. It would be the equivelant of inserting an object in excel and manually adding the .msg file.
– Paul Whittem
Nov 14 '18 at 10:11
1
@PaulWhittem If you know how to do it manually you can at least start doing the same (for this part) with the macro recorder to get an idea how to insert an object. • Additionally you will need a loop going through your Outlook folder (there are tutorials for that) and save the massages as.msgfile (tutorials available too) so you can insert them in Excel (use macro recorder to see how). • Use this information to start coding your project. If you get stuck or errors come back with your code and your question (you didn't ask one yet).
– Pᴇʜ
Nov 14 '18 at 10:38
add a comment |
0
0
0
I will have a folder in Outlook with emails or perhaps a folder on the computer where the emails will be saved.
I need to loop through the folder and embed .msg files (including any attachments within the emails) to a tab in Excel. This is for audit purposes so that if someone goes into the Excel file they will be able to open the emails and view any attachments that were provided.
excel vba outlook
edited Nov 17 '18 at 5:06
Community♦
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
I will have a folder in Outlook with emails or perhaps a folder on the computer where the emails will be saved.
I need to loop through the folder and embed .msg files (including any attachments within the emails) to a tab in Excel. This is for audit purposes so that if someone goes into the Excel file they will be able to open the emails and view any attachments that were provided.
excel vba outlook
excel vba outlook
edited Nov 17 '18 at 5:06
Community♦
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
edited Nov 17 '18 at 5:06
Community♦
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
edited Nov 17 '18 at 5:06
Community♦
11
edited Nov 17 '18 at 5:06
Community♦
11
edited Nov 17 '18 at 5:06
Community♦
11
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
asked Nov 14 '18 at 9:35
Paul WhittemPaul Whittem
11
11
1
What do you mean by "add the emails to a tab in Excel"? Do you mean embedding the .msg file, transcribing the content to cells, adding a link to a location on your file system or something else entirely? In any case, the question's too broad to get a useful answer here.
– jsheeran
Nov 14 '18 at 9:40
Hi there, sorry. I didn't think the question was too broad but I see your point now I re-read it. yes it would be embedding the .msg file so that when someone goes back into the file they can always access the original emails that relate to the file. It would be the equivelant of inserting an object in excel and manually adding the .msg file.
– Paul Whittem
Nov 14 '18 at 10:11
1
@PaulWhittem If you know how to do it manually you can at least start doing the same (for this part) with the macro recorder to get an idea how to insert an object. • Additionally you will need a loop going through your Outlook folder (there are tutorials for that) and save the massages as.msgfile (tutorials available too) so you can insert them in Excel (use macro recorder to see how). • Use this information to start coding your project. If you get stuck or errors come back with your code and your question (you didn't ask one yet).
– Pᴇʜ
Nov 14 '18 at 10:38
add a comment |
1
What do you mean by "add the emails to a tab in Excel"? Do you mean embedding the .msg file, transcribing the content to cells, adding a link to a location on your file system or something else entirely? In any case, the question's too broad to get a useful answer here.
– jsheeran
Nov 14 '18 at 9:40
Hi there, sorry. I didn't think the question was too broad but I see your point now I re-read it. yes it would be embedding the .msg file so that when someone goes back into the file they can always access the original emails that relate to the file. It would be the equivelant of inserting an object in excel and manually adding the .msg file.
– Paul Whittem
Nov 14 '18 at 10:11
1
@PaulWhittem If you know how to do it manually you can at least start doing the same (for this part) with the macro recorder to get an idea how to insert an object. • Additionally you will need a loop going through your Outlook folder (there are tutorials for that) and save the massages as.msgfile (tutorials available too) so you can insert them in Excel (use macro recorder to see how). • Use this information to start coding your project. If you get stuck or errors come back with your code and your question (you didn't ask one yet).
– Pᴇʜ
Nov 14 '18 at 10:38
1
1
What do you mean by "add the emails to a tab in Excel"? Do you mean embedding the .msg file, transcribing the content to cells, adding a link to a location on your file system or something else entirely? In any case, the question's too broad to get a useful answer here.
– jsheeran
Nov 14 '18 at 9:40
What do you mean by "add the emails to a tab in Excel"? Do you mean embedding the .msg file, transcribing the content to cells, adding a link to a location on your file system or something else entirely? In any case, the question's too broad to get a useful answer here.
– jsheeran
Nov 14 '18 at 9:40
Hi there, sorry. I didn't think the question was too broad but I see your point now I re-read it. yes it would be embedding the .msg file so that when someone goes back into the file they can always access the original emails that relate to the file. It would be the equivelant of inserting an object in excel and manually adding the .msg file.
– Paul Whittem
Nov 14 '18 at 10:11
Hi there, sorry. I didn't think the question was too broad but I see your point now I re-read it. yes it would be embedding the .msg file so that when someone goes back into the file they can always access the original emails that relate to the file. It would be the equivelant of inserting an object in excel and manually adding the .msg file.
– Paul Whittem
Nov 14 '18 at 10:11
1
1
@PaulWhittem If you know how to do it manually you can at least start doing the same (for this part) with the macro recorder to get an idea how to insert an object. • Additionally you will need a loop going through your Outlook folder (there are tutorials for that) and save the massages as
.msg file (tutorials available too) so you can insert them in Excel (use macro recorder to see how). • Use this information to start coding your project. If you get stuck or errors come back with your code and your question (you didn't ask one yet).– Pᴇʜ
Nov 14 '18 at 10:38
@PaulWhittem If you know how to do it manually you can at least start doing the same (for this part) with the macro recorder to get an idea how to insert an object. • Additionally you will need a loop going through your Outlook folder (there are tutorials for that) and save the massages as
.msg file (tutorials available too) so you can insert them in Excel (use macro recorder to see how). • Use this information to start coding your project. If you get stuck or errors come back with your code and your question (you didn't ask one yet).– Pᴇʜ
Nov 14 '18 at 10:38
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53296968%2fembedding-outlook-email-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53296968%2fembedding-outlook-email-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What do you mean by "add the emails to a tab in Excel"? Do you mean embedding the .msg file, transcribing the content to cells, adding a link to a location on your file system or something else entirely? In any case, the question's too broad to get a useful answer here.
– jsheeran
Nov 14 '18 at 9:40
Hi there, sorry. I didn't think the question was too broad but I see your point now I re-read it. yes it would be embedding the .msg file so that when someone goes back into the file they can always access the original emails that relate to the file. It would be the equivelant of inserting an object in excel and manually adding the .msg file.
– Paul Whittem
Nov 14 '18 at 10:11
1
@PaulWhittem If you know how to do it manually you can at least start doing the same (for this part) with the macro recorder to get an idea how to insert an object. • Additionally you will need a loop going through your Outlook folder (there are tutorials for that) and save the massages as
.msgfile (tutorials available too) so you can insert them in Excel (use macro recorder to see how). • Use this information to start coding your project. If you get stuck or errors come back with your code and your question (you didn't ask one yet).– Pᴇʜ
Nov 14 '18 at 10:38