Outlook 2010 macro to extract data from email

[jeskit]

Hi

I have written this macro in Microsoft Outlook 2010 which opens an excel workbook and then from the open email extracts data from the email and inserts it into the excel workbook.

Please Login or Register  to view this content.

However does anyone know how to add a line which says if there is an attachment place the name of the file into column H else put False into column H?

Thanks

Jeskit

[Domski]

You can check for attachments like this I think:

Please Login or Register  to view this content.

Would need more info as to how you would deal with multiple attachments to be more specific.

Dom

[jeskit]

Hi

Thanks for that, that works!

Would you know that the item class is for attaching the name of the attachment?? I ahve tried .Attachments, .AttachmentsAdd but they didn't work.

Thanks

[Domski]

Something like this:

Please Login or Register  to view this content.

Dom

[anchuri_chaitanya]

Hi,.

Can anyone help me in getting out of this..

In outlook emails, if in the body of a mail contains like any tables.. how to get that table of contents from the body of a mail to excel cell by cell using macro programming..

Please help me with the code.....

urgently needed.....



Thanks & Regards
Chaitanya Balaji

[Domski]

You should start your own thread rather than posting a question in another persons per the forum rules.

Dom