automatic email

Results 1 to 2 of 2

Thread: automatic email

  1. #1
    Join Date
    Dec 1969

    Default automatic email

    Hi,<BR><BR>I&#039;m trying to fire off an email at a scheduled time every week. the email will contain the 10 ten records from my db. I have the select statement etc all working fine, and I&#039;ve written an asp page which sends the mail using <BR>Set objMail1 = Server.CreateObject("CDONTS.NewMail")<BR>Is there a way of automating an email using Sql server?

  2. #2
    Join Date
    Dec 1969

    Default RE: automatic email

    1) use WSH (search on )<BR><BR>2) use SQL job agent

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts