Generat email from excel

[dgkindy]

I had created the function to generate an email which worked fine, now that I am in Outlook 2003 it does not work

This is the line that is causing the error.
Set OutApp = CreateObject("Outlook.Application")

Any comment?

Please Login or Register  to view this content.

End Sub

[ninja0059]

dgkindy,

I am actually attempting to do the same thing, but am stuck in the general macro. Would it be possible for you to post the excel file you are using? I would love to have something to model.

Thanks

[dgkindy]

Not sure what you want here. The spreadsheet is getting a bit on the large size. If you paste the code listed above, you can modifiy it to work in your work sheet assuming you do not have the same problem I am currently having.

[dominicb]

Good afternoon dgkindy / ninja0059

Can't help you out on the code side guys as I have Lotus Notes and consequently can't test anything, but would suggest you visit Ron de Bruin's site which has tons of code examples and an add-in which contains wrapper routines - suggest you have a look :

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/mail/add-in.htm

HTH

DominicB