stored procedure for sending email into my application

See more:

SQL-Server

SQL-Server-2008

Hi,

i have 2 table let us say customer and queuemail. i have to retrieve all email id of that column from customer table and inserted into queuemail table with additional columns as mentioned below. when a user in customer table registered in before today’s date on i.e,[CreatedOnUtc] field then i want to send message to all the users.

Please help me out on this. i dont want gmail pattern answers.
this is for my application itself not globally.

Queuemail table
SELECT TOP 1000 [Id]
,[Priority]
,[From]
,[FromName]
,[To]
,[ToName]
,[CC]
,[Bcc]
,[Subject]
,[Body]
,[CreatedOnUtc]
,[SentTries]
,[SentOnUtc]
,[EmailAccountId]
FROM [QueuedEmail]

customer table
SELECT TOP 1000 [Id]
,[CustomerGuid]
,[Username]
,[Email]
,[Password]
,[PasswordFormatId]
,[PasswordSalt]
,[AdminComment]
,[LanguageId]
,[CurrencyId]
,[AffiliateId]
,[Active]
,[Deleted]
,[IsSystemAccount]
,[SystemName]
,[LastIpAddress]
,[CreatedOnUtc]
,[LastLoginDateUtc]
FROM [Customer]