> Respected all
> Is there any method to copy & paste data from attached file in mail without using traditional method ?
>
> I receive 10-15 mails daily with attached CSV/XLSx. We do following to copy & paste
>
> 1.open mail
> 2.download file
> 3. copy data
> 4 paste in one excel named as COMBINED
>
> this is a irritating task for me, if any of you can suggest any method to solve the issue using Excel macro or VFP.
1. Automate Outlook.
2. Find the e-mail that contains the attachment you are looking for.
3. Save the attachment in a folder.
4. Automate Excel to open the saved attachment, copy the data, open another workbook and paste into it.
Start with that and come back if you have questions.
Mike Gagnon