Emailing form Excel Using VBA

[nickysquawkes]

Hi,

I have a list of data in Excel that I want to generate an automated email from. i am able to generate these emails but it always attaches the workbook itself. Is anyone able to provide an example of how to send an email so that I can alter the following using the list I have in Excel.

To:
From:
Subject:
Body:

I would also like to be able to stop the warning message that an email is being generated automatically

Any suggestions would be greatly recieved

Thanks
Nick

[royUK]

You can change that, post bthe code that you are using. Remember Code Tags.

The warning is a Microsoft Security issue & code to avoid this should not be published.