Vba Macro to copy email body details to excel

[briti]

Hi,

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

0down votefavorite ​

I have got 100 plus email in a folder and all of them have got an attachment. I want to create a package which will copy the data from all email attachments in one excel sheet and also add a column which will have the received dates of those emails against the data.Can any one guide me how to do it with help of ssis package.

<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
</tbody>

</body>I have got 100 plus email in a folder.I want to create a macro that will copy all the body details of email in an excel sheet and also add a column which will have the received dates of those emails against the data in each row.[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]Can any one guide me how to do it.[/FONT]

 

[Macropod]

Cross-posted at: https://stackoverflow.com/questions...l-attachments-to-excel/46803408?noredirect=1#
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[briti]

Hi Paul,

The query posted on stackoverflow is totally different.By error the entire query is c/p.My query is as follows.

I have got 100 plus email in a folder.I want to create a macro that will copy all the body details of email in an excel sheet and also add a column which will have the received dates of those emails against the data in each row.Can any one guide me how to do it.

 

[Macropod]

This:

I have got 100 plus email in a folder and all of them have got an attachment. I want to create a package which will copy the data from all email attachments in one excel sheet and also add a column which will have the received dates of those emails against the data.Can any one guide me how to do it with help of ssis package.

is identical in both forums; indeed it is all you posted at stackoverflow. Hence, they're anything but totally different; you're asking for help with the same problem on both forums. Kindly abide by this forum's rules.

No-one should help you here until you notify stackoverflow of the cross-post.

 

[briti]

it was posted by mistake.

 

[Macropod]

So, you want someone to work on a VBA solution to the same problem you have stackoverflow working on with a different approach and you think they're not entitled to know about that???

 

[briti]

over here i have requested in order to get data from mail body.have made two different request, as said earlier it was posted by mistake

 

[Macropod]

If you want help with something here that is materially different from what you've asked for at stackoverflow, start a thread dealing with that. Thread closed.