Solved

outlook email without warning message

Posted on 2009-07-16
8
545 Views
Last Modified: 2013-12-18
Im using Sybase trigger to send email to clients (notification), but always i receive confirmation message (program try to send email....).
How I can stop that message?
Note I use Sybase trigger not programming language!

Thanks

ALTER PROCEDURE "amos"."send_email"(@mail_from varchar(80),@mailto varchar(80),@e_subject varchar(255),@msg long varchar) as /* @parameter_name parameter_type [= default_value] [OUTPUT], ... */
begin
  declare @rc integer
  execute @rc = xp_startmail mail_user = @mail_from
  --If successful logon to mail
  if @rc = 0
    begin
      execute @rc = xp_sendmail recipient = @mailto,subject = @e_subject,"message" = @msg
      --If mail sent successfully, stop
      if @rc = 0
        execute xp_stopmail
    end
end

Open in new window

0
Comment
Question by:Deyhim
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 10

Expert Comment

by:Madjax
ID: 24867776
Hello Deyhim,
Try this,
1. Create a certificate through START > All programs > Microsoft Office > Microsoft Office Tools > Digital Certificate for VBA Projects
2. Then ALT+F11 from Outlook to bring up editor
3. Tools > Digital Certificate > Choose > (select your certificate) > Click OK twice
4. This should do it I think.
/MadJax
0
 
LVL 1

Author Comment

by:Deyhim
ID: 24867845
i dont have " Digital Certificate for VBA Projects " in my office
im using MS Office 2003
0
 
LVL 1

Author Comment

by:Deyhim
ID: 24867857
one more thing is im using MS Office 2003 but outlook 2007.
0
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 
LVL 1

Author Comment

by:Deyhim
ID: 24868356
No Answer !!! its Urgent
0
 
LVL 10

Expert Comment

by:Madjax
ID: 24880543
Then I don't know sorry. The above has helped me when I put in macros / script into Outlook, but I use 2003
0
 
LVL 10

Accepted Solution

by:
Madjax earned 500 total points
ID: 24880570
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Changing a few Outlook Options can help keep you organized!
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question