PDA

View Full Version : Transfer Selected Body Content from Outlook to Excel



JOEYSCLEE
11-20-2016, 07:38 AM
Hi, there
Could you please help to advise the macro for transferring the selected text from Outlook email body to Excel worksheet directly?

Actually, I have daily email which state with different style# & comment in the email. Then, I need to insert the new comment to the different cell of the related style# in the Excel Worksheet.

Example:
Date: 11-11-2016
Comment from XYZ
Style# : 1234
Color : EE1111, ******x
******, *********xx, ******xx

Comment from XYZ
Style# : 6789
Color : BB1111, ******x
******, *********xx, ******xx

Hence, I want the selected text from Outlook email to copy to "insert comment" of single Cell in the specified Excel worksheet directly.
Or, copy those text into single cell of the specified Excel worksheet.

Expected Result As Below
17654

snb
11-20-2016, 09:20 AM
See:

http://www.snb-vba.eu/VBA_Outlook_external_en.html#L153