Memos and xp_sendmail?

Results 1 to 2 of 2

Thread: Memos and xp_sendmail?

  1. #1
    Join Date
    Dec 1969

    Default Memos and xp_sendmail?

    I&#039;m trying to send email alerts to customers, and the body of the message to be sent will be partly taken from a memo field in SQL Server 7. Does anyone have any idea how to do this? I don&#039;t want to send the data as an attachment, which leaves me with the 80 character line length limit. At the moment, I&#039;m reading the entire mail into a temporary table, then using SELECT text FROM temptable ORDER BY lineno to send the data out OK, but that&#039;s with single line text fields, all under 80 chars. I need to get it to process a multi liner, and I&#039;m stuck! Help!!<BR><BR>Thanks in advance<BR><BR>Tim Boswell

  2. #2
    Join Date
    Dec 1969

    Default RE: Memos and xp_sendmail?

    How are use selecting your records (with a programming language???)?

Posting Permissions

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