Email Excel spreadsheet using a macro

[dwilson38550m]

I have created several spreadsheets using a macro (the spreadsheets created are remittance advices to be sent out to suppliers). Is there any way I can create a macro to email these spreadsheets out to suppliers (using email details contained in a predefined list)?

Thanks

 

[Andrew Poulsom]

You should find what you want here:

http://www.rondebruin.nl/sendmail.htm

 

[Bagsy]

Take a look at this. This was given to me by Michael Ro
This will list all the excel files in a folder and put them in column “A”, it will then e-mail to the e-mail addresses in column “B”.
I have put a VLOOKUP in column “B” which looks at the file name and enters the correct E-mail addresses. (I have created a VLOOKUP table with all the possible file names, in my case customer names and the corresponding e-mail addresses).This way if the files stored in your folder change, column “B” will always enter the correct E-Mail addresses
You may be able to use parts of this code.

http://www.mrexcel.com/board2/viewtopic.php?t=164558&highlight=