Copy Email Body to Excel paste value (Match Destination Formatting)

[korekurd]

using the below code Im able to copy Date and Time and the body of each email in specific folder in outlook to Excel into cell A3 and B3 one at a time. However, the entire body is copied onto one cell. I need to add the following functions:

to copy from a specific text from the body "NAME:" to the end of the body and Paste Value to cell B3

when I manually copy the body and paste over I get Match Destination Formatting on the right click as an option which is exactly how I wanted to be Pasted over. this does not copy the entire Body to just B3 matches what the body of the email looks like into excel.

Please Login or Register  to view this content.

[vba_php]

not clear on what you're asking. you said this:

However, the entire body is copied onto one cell.

OK, well that is clear obviously.

but then:

when I manually copy the body and paste over I get Match Destination Formatting on the right click as an option which is exactly how I wanted to be Pasted over. this does not copy the entire Body to just B3 matches what the body of the email looks like into excel.

not getting that either. It's not clear. can you clarify? what line of code is the problem?

[korekurd]

Sorry for the confusion. This line Is not exactly what I need Range("B2").Offset(i, 0).Value = OutlookMail.Body. With this line the body of the email is in “B3” and “B3” only. The email consist of the following

“Name:
Employee:
Signature_____________”

Followed by a table 10 columns x 61 rows.

The above codes puts everything including the table in Cell B3. I need the formatting from the table in the body to transfer as is to excel.

Also the email also included text or messages before

“Name:
Employee:
Signature_____________”

I will not need anything before this just start with it and the table below.

hope this makes it more clear.

[korekurd]

The email layout can be viewed in excelforum.com post number 5388245

[vba_php]

The email layout can be viewed in excelforum.com post number 5388245

post the URL, please?

[korekurd]

I get the following error message when trying to post links "You are not allowed to post any kinds of links, images or videos until you post a few times."

the post title is "Re: VBA extract Data from specific location in body of Outlook To Excel"

[vba_php]

put the URL link in a text and upload the .txt file as an attachment to your post. either that or take a screenshot of the URL on your computer (use the PRINT SCREEN button or the GAME BAR in win 10) and upload that image file to your post.

[korekurd]

Here is the image

[vba_php]

no one answered you in the other thread. maybe that's because you addressed people here as ""the TEAM""? That sounds a little strange to me, man. no one gets paid here for helping. regardless, I will look at this issue of yours later today.

https://www.excelforum.com/excel-pro...-to-excel.html

[korekurd]

Thanks vba_php for the feedback.

with the above email body format in the image above, Im trying to accomplish the following:

To copy everything starting from "NAME:" to the end of email body and get it Pasted with to excel keeping the format. Thank you so much for helping me out. Let me know if I need to clarify anything else.

Thanks

[vba_php]

ok korekurd,

I have now looked at this. here are my questions for you, which should open this up to discussion:

=> what TYPE of object is in the image you posted? (I have also included the image again at the bottom of this post). is it an embedded word doc? that's what it looks like, considering that it looks like it has mail merge fields in it.

=> is it just ONE object? or is the calendar an object, and the rest of the text just in the actual email itself?

=> HOW did you get the content into the body of the email to begin with? copied it from another source and pushed the PASTE button in Outlook?

=> obviously you are trying to automated the capturing of the data that your customer fills in after you send that to them. more than likely, when they do fill it out, it will come back to you in the same form/layout/nature that you sent it in, regardless of what email client they are using.

=> how familiar are you with Outlook's VBA object model? that knowledge would help you out a great deal here.

So.....please answer all of those and we will proceed with a solution and/or ideas on how to do this. If indeed, there is a solution.

[korekurd]

So sorry for the late reply but I was able to find something online and modify to my preferences but got it to work. here was my final product just incase others are looking for solution. its copying Tables in email body to Excel that I need done.

Please Login or Register  to view this content.