Has anyone else encountered this?
I have a script to to a find on certain email addresses, (find works ok) then send an email through the server (SMTP). However the email has the embedded text, but not the field info that should be next to it. The field info is just blank. Looks something like this:
To: Email addresses ( find is okay)
Subject: New Job Notification for: (Field here is blank)
Body: Enclosed is a new job notification for customer: (field here is blank), for PO number: (Field here is blank)
I have the tables related, but not sure why the data is just not there. The message will send okay, the SMTP settings are correct, but the field data just won't show. Do all the fields need to be in the same table? or the same layout? I've tried putting them everywhere but cannot get this to work.
Any ideas or suggestions? Been working on this one for... ever.
Thanks! Appreciate ANY help with this!