Hi,
I am currently working on a VMS Oracle Forms application that requires mails to be sent from a unix mail box having built up the mail message from some SQL statements which is the mailed to the unix box.
I have it all working mighty fine, including the attachments necessary, but, for the life of me I cannot get it to send to the CC address.
I have the following SQL :-
SELECT 'To: <'||'&var7'||'>'||chr(10)||
'Cc: bevs_williams@carrotmail.com'||chr(10)||
'From: '||<snip>
And the To, From and the body works fine, (I use my work
email for '&var7') but it will not send to the Cc address.
Have I got the To,Cc and From in the right order? When I
receieve my mail, it does have the address bevs_williams@carrotmail.com on the line, but I don't get the mail.
Any pointers would be very much appreciated.
Regards,
Bev.
You need to post a copy of a text message with header information after all the SQL statements are done and the message is composed and ready to be sent. It would also be helpful to see the exact command that the UNIX platform is using to send the message.
Neo,
This is the very top of the text file that is sent from
the vms instance by vms mail to the unix address which
then sends it on.
To: <ba.willia@elsevier.co.uk>
CC: <r.stevenson@elsevier.co.uk>
From: Mr A. Wood <a.wood@elsevier.co.uk>
Kidlington, 21 December 2000
I'm afraid I have had to snip the rest of the file due to
sensitive information.I have tried other combinations - putting the cc after the from but to no avail.
In the vms script this starts the SQL which creates the
letter into a .lis file.
START PTS\_M111_EMAIL.SQL
then
$ CONVERT/FDL=PTS$FDL:STREAMLF PTS_M111_EMAIL_9999.LIS PTS_M111_EMAIL_9999.LIS
$ PURGE/NOLOG PTS_M111_EMAIL_9999.LIS
$ uuencode :== $ut_exe:UUENCODE
$ uuencode terms1.pdf
$ APPEND terms1.UUE PTS_M111_EMAIL_9999.LIS
$ MAIL/SUBJECT="Your paper SYNMET 54546 submitted to Synthetic Metals" pts_m111_email_9999.lis "pts.relay@elsevier.co.uk"
The pts.relay address will then forward on the mail using the .lis file top create the To from, cc and header.
This is the first time that cc has been required, but the rest works just fine.
Neo,
I have managed to track down someone that is going to check that the cc part of email is supported in the script that is run, so hopefully I will get some joy from them. Thanks for your help and I hope you have a great Christmas and New Year.
Regards,
Bev.
[Edited by bevs_williams on 12-21-2000 at 10:27 AM]
Since the UNIX platform sends the message, the UNIX mailer is the key to how RFC822 information (SMTP header information) is parsed. Not all mailers are equal. When you find out what mail is used and where it is being called, this will help you troubleshoot the problem.
