email with recordset data

Results 1 to 2 of 2

Thread: email with recordset data

  1. #1
    Join Date
    Dec 1969

    Default email with recordset data

    I wish to create a simple email link that includes a field from a results recordset, so... I have the link and the subject and some body text BUT how can I insert the field from the recordset??? Thanks for reading, I am stuck fast.

  2. #2
    Join Date
    Dec 1969

    Default RE: email with recordset data

    Query the data as normal, then you can either concatenate a string using Loop reading the recordset:<BR><BR>EmailStr = ""<BR>Do While Not rs.EOF<BR>EmailStr = EmailStr & rs("MyField")<BR>rs.moveNext<BR>Loop<BR><BR>or for performance you can use GetRows with Join command to convert an array to a string, see the FAQ&#039;s on this..

Posting Permissions

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