Excel VBA to Attach File And Automatically Send Email

[Friel300]

you could add the mail that you want to forward to the attachments.

[malay]

Hi,

Thank you for the reply...but let me expand the question for your better understanding.

I have copied some mails from outlook inbox to a folder. Some mails are with attachments and some are without. I need to automate it with excel vba to forward those mails to an email ID that i provide in one cell of excel sheet. I need to forward the mails to keep the format and attachments unchanged. Please help me to solve the problem as it's a project I am doing and having problem solving it on time.

Regards,
Malay