Functionality to send mass email to suppliers

[Nivant]

I have a requirement to send an email attachment to our suppliers that are in Oracle . It is not a PO document that i am sending but it is an email attachment that could be a word doc or a PDF. Can you please suggest any solutions. It is urgent

[kamaltiwari]

please make it more clearer...what exactly u wanna to do....

[Nivant]

Hello Kamal,
Thanks for your initiation to help me. We have lot many Vendors and Suppliers in Oracle. We want to send a mass email to all our suppliers as in an email to send them greetings or an email to thank them for being good Vendors or suppliers. Any viable solution would be great and helpful

[admin]

I don't think that there is any standard functionality available. There are two possible solutions,

1- Develop your own form and pick email id's of your supplier and send email,

topic.asp?TOPIC_ID=12

2- Create a PL/SQL to send email and pick email id's and send email,

http://asktom.oracle.com/pls/asktom/f?p ... 1265038428

Thanks