Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

Retirement Notice

Baanboard is shutting down on 31-dec-2023. See: http://www.baanboard.com/baanboard/showthread.php?t=76043


User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
20%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
40%
Focus on process automation/ integrations/ Real time data/ BI analytics
13%
Stick to basics
27%
Total votes: 15

Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th May 2004, 00:38
LittleJohn's Avatar
LittleJohn LittleJohn is offline
Senior Member
 
Join Date: Oct 2001
Location: CA
Posts: 184
LittleJohn is on a distinguished road
Baan: Baan4c2, Baan Vc - DB: SQL 2000, 7.0 - OS: Win 2003, Win2K Adv Server
Question Email

I'm trying to send email from baan directly (probably a frequently asked question here )

Created a VB utility that simply reads the parameters (to, from, subject etc..) from a text file and sends the email through Outlook.
The only problem is, When the application is sending this email, Windows/Outlook comes up with a popup window with a mesg that says something like "An unauthorized email is being sent out, Could be a virus. Would you like to continue Y/N" ?
If I click on "Yes".. the email is sent successfully... otherwise not.

Is there a way to block this or get that "yes" 'clicked' in the background ?

This never happened on Windows 2k. Happens only on XP.
If i send that email from my server, the message does not popup, since the server is on Win2k. But If i send the email from my PC ( on XP), the message pops up.

All suggestions are welcome. Thnks

Cheers
Reply With Quote
  #2  
Old 12th May 2004, 03:04
p.cole's Avatar
p.cole p.cole is offline
Senior Member
 
Join Date: Nov 2001
Location: Portsmouth, UK
Posts: 265
p.cole is on a distinguished road
Baan: Baan IVc4 SP20, ERP LN FP3 - DB: MSSQL 2005 - OS: W2K3
There are various ways to do this:

Option 1: As you suggest, email a file on the client PC using a third party program (e.g. mailx). You can use various programs to do this. I have seen third party applications started in a DOS/cmd shell window, but this creates a temporary window that pops up on the users screen and looks unprofessional.

Option 2: Using Outlook via COM automation. Using standard COM components will give you the warning message you report, which was part of Microsoft 98 Outlook Security patch (thanks to the Mellisa virus). To get around this a seperate COM components has been developed called Outlook Redemption, see here http://www.dimastr.com/redemption/ . We use this via automation with vb scripting (.vbs) and windows scripting host (wscript.exe). The advantage is that all emails sent are added to the users sent items folder, but the downside is that if any outlook errors occur sending the mail (e.g. mailbox is full/over size limit) then a vbs script error will have to be handled gracefully.

Option 3: Send the mail on the server. One way to do this is to have a report run to the ASCIF device using the brp.*() functions, and then start off an server side application (with run.prog() ) to process the report and send any emails. I prefer using perl with MIME::Lite to do this, mainly because it is platform independent and freely available, but any scripting language should do. Advantage: more likely to work, disadvantage: difficult to handle errors in the processing, e.g. bad email addresses.

Hope this helps.

Phil
Reply With Quote
  #3  
Old 12th May 2004, 06:31
LittleJohn's Avatar
LittleJohn LittleJohn is offline
Senior Member
 
Join Date: Oct 2001
Location: CA
Posts: 184
LittleJohn is on a distinguished road
Baan: Baan4c2, Baan Vc - DB: SQL 2000, 7.0 - OS: Win 2003, Win2K Adv Server
Smile Great...

Hi Phil,

Thanks for your suggestion. Option 2 sounds great.

I'll read up more on that and try to use that. The COM component you are using, is that a generic one that can be directly downloaded & used or would that be requirement specific ?
( The utility we have is in VB and developed inhouse.. is there some such COM component that can be re-used) ?

Thanks again for your help.

Cheers
Reply With Quote
  #4  
Old 20th May 2004, 16:36
LittleJohn's Avatar
LittleJohn LittleJohn is offline
Senior Member
 
Join Date: Oct 2001
Location: CA
Posts: 184
LittleJohn is on a distinguished road
Baan: Baan4c2, Baan Vc - DB: SQL 2000, 7.0 - OS: Win 2003, Win2K Adv Server
Thumbs up works...

Hi Phil,

The redemption dll works cool.
Thnks for the suggestion !!

Cheers
Reply With Quote
  #5  
Old 24th May 2004, 07:15
manojsharma's Avatar
manojsharma manojsharma is offline
Senior Member
 
Join Date: Sep 2002
Location: Delhi
Posts: 200
manojsharma is on a distinguished road
Baan: 4C4, 5, Baan LN - DB: Oracle,informix - OS: Unix, NT, Windows-2000
Hi John,

Could you please post your VB Script and tell me the path where it is to be copied.

thanx
__________________
Together we can and we will make a difference
Reply With Quote
  #6  
Old 24th October 2007, 09:22
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,876
Hitesh Shah is on a distinguished road
Baan: ERP Ln - DB: MSSQL - OS: Windos
outlook advanced security

Another alternative to redemption http://www.mapilab.com/outlook/security/ available free for outlook security.
__________________
Hitesh R Shah
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Baan Reports by Email bamnsour Third Party Products 3 19th June 2013 17:29
EMAIL output with Outlook.rtf Mick Andrus Tools Administration & Installation 11 12th September 2011 08:17
How to send email from within Baan? Ilansu Tools Development 19 8th April 2010 07:55
Bogus email from staff@baanboard.com patvdv About Baanboard.com 0 11th March 2004 12:36


All times are GMT +2. The time now is 00:52.


©2001-2023 - Baanboard.com - Baanforums.com