scrapping from mail

Hi,
Like sending mail from excel. Is it possible to retrieve the attachments from the mail and save in the folder. and the names of the attachment and saved folder path should be put in a column .
Can anyone share sample code for the same? i can modify it or it will help me in getting started. I cannot share the mail pswd..

Hi,
Anybody can help with respect to this?
I have around 600 mails.. I need to download each one manually and i have note the date of download and storage location in excel sheet.
Is there a way to scrap using vba by downloading attachments and extracting the name and path along with date to excel.

Hi dorabajji,

See posts #3 and #4 in the following thread and the attached files: https://www.excelforum.com/excel-pro...-c-by-vba.html

One file has simple examples that you should be able to follow and modify.

The other file probably does what you want and a lot more, but may be difficult to use and more difficult to follow the code. This can save the body of the emails at .txt, .mht (standalone HTML), .msg, or .pdf files. It also can save attachments for each email.

Attachment names have 3 parts to make sure each attachment is unique:
a. Sender, Date/Time Sent, Title
b. the word 'Attachment'
c. Actual Attachment name

Attachments will not be saved using the 'List' Option.

Suggestions for use (processing is slow, approximately 1-2 seconds per email):
a. Put the files you download in a folder that contains no other files.
b. Copy or move a small number of emails in outlook to their own outlook folder
c. Test the options in the program until you find something you want.

Good luck.

The following code saves all attachments for one Outlook Email:

Please Login or Register  to view this content.

Lewis

Hi Metzger,
I will check.. thanks..
And is it possible like from gmail too?
Like cdo lib fr sending.. is it possible other than outlook?

Thanks... Will check..