Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send report via email not as attchment using email address in table.

Status
Not open for further replies.

itsmythg

Technical User
Apr 4, 2001
34
US
this problem may have already been addressed but after hours of looking thru these posts, I havn't found one that is clear enough for me to understand, being that i am a little slow about understanding unless i see my field names in the code. i have decided to post my question.

i have an Report based on a query, some fields are a part of the report.

MAC NUMBER:<field in DB> Requested For <username field in DB>
User info:<usrid from field in DB>
Body of Report

the database also has a field for email address.
What i would like to do is to email the report as the body of the email (not as attachment) and if possible pull the email address field to address the email. put in a defauld to and bcc email. and even inser the workorder number as the subject line.
Let me say thank you in advance, people here are always willing to help and we don't see that enough in this world sometimes.
Roxanne
 
How about trying one of these threads, and if you get stuck, post back?

thread181-1091473
thread702-1114426
thread705-1114129



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top