Vba Macro to copy email body details to excel

Status
Not open for further replies.

briti

New Member
Joined
Oct 22, 2017
Messages
4
Hi,

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

<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;">
[TD="class: votecell"]
0down votefavorite
[/TD]
[TD="class: postcell"] 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.


[/TD]

</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]
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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.
 
Upvote 0
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.
 
Upvote 0
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???
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top