Products

b2Mail-Merge Frequently Asked Questions

If you wish to email out of Baan/ERP/LN, you can choose one of three products from the B2Email family. The following summery shows the different B2Email Products and the main features in each one.

Feature B2Email StandardVersion B2Email Plus Version Baan Mail-Merge
Report in PDF Text or Body Yes Yes Yes
Report in XLS or XLSX format Yes Yes  
Report in DOC or DOCX format   When bundled with B2Win  
Report in RTF, HTML, XML, CSV, BPF Yes Yes Yes
Can run in a job Yes When bundled with B2Win Yes
Can run in a cron job Yes   Yes
Make hard copies of output on a network drive or the Baan server Yes   Yes
Background image (Stationary)   When bundled with B2Win Yes
Header and Footer images (logo) Yes Yes Yes
PDF Logo Yes Yes Yes
Signature Yes Yes Yes
E-mail Print-screens from Baan Sessions   Yes  
Integrate with Baan Hot Link   Yes Yes
Fax out of Baan   Yes Yes
Includes an interactive Interface   Yes Yes
Use Supplier, Customer, Employee and general Address books   Yes Yes
Manually add attachments to the report sent out of Baan Yes Yes Yes
Full-Automatic mode Yes When bundled with B2Win Yes
Cut a long output run (Like SO Ack., PO or Invoices) into multiple documents that are automatically faxed, e-mailed, printed and archived     Yes
E-mails and Fax numbers are automatically picked by the system, based on customer/supplier/business partner data     Yes
Automatic attachments based on pre-defined logic     Yes
Customized Mail-body     Yes
Printing on multiple printers     Yes

"B2Email Standard" and "B2Email Plus" fit here. With both products you can send any Baan report and convert it to (PDF, XLS,DOC,HTML, XML and TXT), "B2Email Plus" version has a friendly interface while "B2Email Standard" version uses switches and command lines and it also has a smart broker where you can pre-define email address for a specific report to be sent. (This is why "B2Email Standard" is compatible with Baan batch / job running processes). 

With "B2Email Plus" you can email, fax and print. With "B2Email Standard" yon can email, print and archive but faxing is not supported.

"B2Email Standard" and "Baan Mail-Merge" fit here. With both versions you can pre-define your report to be sent to a specific email address. "Baan Mail-Merge" has a smarter broker where you can for example run a range of Sales Order Acknowledgement and "Baan Mail-Merge" will cut each sales order and produce a PDF out it and also find the proper customer email address or fax number. It can run in a fully automatic mode or in One by One mode where it prompts each order before sending.

There are five methods for sending emails from Baan used in B2Email Standard, B2Email Plus and Baan Mail-Merge.

  1. PC-blat: Copies all necessary files to the local PC and sends the email using SMTP freeware mailer "blat" from the local PC.
  2. NT-blat: NT Server Application. Emails are sent from the Baan NT server using SMTP freeware mailer "blat".
  3. Sendmail: Unix Server Application. Emails are sent from the Baan UNIX server using sendmail.
  4. Outlook-Quite/Lotus-Quite: Copies all the necessary files to the local PC and sends email using Microsoft Outlook/Lotus Notes through an API that is launched quietly from the local PC. The email is automatically sent from Outlook/Lotus without any human intervention.
  5. Outlook-Up: Copies all the necessary files to the local PC and sends email using Microsoft Outlook from the local PC. Outlook is launched with all information coming from Baan, and the user can interactively choose more email options and then send the email message from within Outlook.

The following tables show advantages/disadvantages of each method.

 

PC-blat

NT-blat

sendmail

Outlook-Q Lotus-Q

Outlook-Up Lotus-Up

Baan on Unix

Yes

No

Yes

Yes

Yes

Baan on Windows Server

Yes

Yes

No

Yes

Yes

Speed

Slower

Fast

Fast

Slower

Slower

Cron Jobs

No

No

Yes

No

No

Windows Jobs

Yes

Yes

Yes

Yes

No

Copies files to PC

Yes

No

No

Yes

Yes

Must Have Outlook/Lotus Notes

No

No

No

Yes

Yes

Messages Saved in

Baan temp

$BSE/tmp

$BSE/tmp

Sent-Items

Sent-Items

E-mail Logs

In Baan

In Baan

In Baan

Sent-Items

Sent-Items

Sender

Defined in application

Defined in application

Defined in application

Userid from Outlook/Lotus Notes

Userid from Outlook/Lotus Notes

Company E-Mail Procedures to be addressed

Must open every client for SMTP sending

Must open Baan Server for SMTP sending

Sendmail to be activated from Baan Server

 

-

 

 

 

This is probably due to the fact that a certain user exists in "users.dat" (File in $BSE/B2Email6/settings) but the file b2e_username.cfg does not exist.

Edit the file "users.dat" manually and remove the entry that does not have a ".cfg" file. 

This is because you are trying the Sendmail device which is reserved for UNIX and not Windows 2003. 

In Maintain device data for MM device, remove the x from the 4GL program. It should be otccom2sns63 and not otccom2sns63x (for version 6.3).

After installing B2Email, the administrator should create profile for each user in the session "tccom2conf6" (make sure that there are permissions read/write to the folder $BSE/B2Email6/settings) other wise the profiles will not be saved and you will keep getting the error "Define user's profile" in "tccom2conf6".
Usually you can find the outgoing server in your outlook or any other software for popping emails (see the example below), if you still cannot find it contact your system administrator, same thing for the port setting and the number of retries (usually the port is 25 and the number of retries is 1). (This is relevant only to the "PC-blat" method)

When sending any report via B2Email the log file is updated (b2Email.log) which is located on the server under the folder "$BSE/B2Email6/settings" the log file saves when was the report was sent, the Baan user who sent it, report name and to whom the report was sent. For checking specific user's log, run the session "tccom2dislog6".

  • By default, the subject of the message is the name of the report. The subject can be customized depending on the product. (For more details on how to customize the subject, read the product documentation).
  • For all B2Email products, the body is a standard message "$BSE/B2Email6/settings/msg_ <lang>.txt" unless the users choose to write one on his own (according to the specific B2Email product).
  • The footer is taken from Employee Data & Company Data. You can define default footer per company by writing the company's footer in a text file and save it under $BSE/B2Email6/settings/footer <company>.cfg. Users can also define footers in tccom2conf6 (per user).

"B2Email Plus" and "Baan Mail-Merge" can support any fax server that has SMTP capabilities. They allow you to fax documents out of Baan/ERP/LN while integrating to one of the following fax servers:

  1. Internet Fax - www.fax.tc
  2. RightFax - www.captaris.com
  3. Fax Maker - www.gfi.com
  4. Ferrari-Fax - www.ferrari-electronic.de
  5. Zeta-Fax - www.equisys.com
  6. Mrs-System - www.cycos.com



The file $BSE/B2Email6/settings/msg_<lan>.txt should have two blank lines before the word "Regards".

We like the ongoing development and the excellent customer service
Fata S.p.A.
NAZDAQ's add-on utilities for Baan have proved to be indispensable software tools
IT Director, Grindmaster
We are very satisfied with the products and reliability of NAZDAQ
Christoph Kern, MM Packaging Europe GmbH
We could reduce the cost of Baan programming
Martin Cajoos, Kistler
Our users find Baan Mail Merge to be fast, effective and easy to use
Barbara Bailey, JVK
NAZDAQ tools are simple to configure and use, and are inexpensive
Venu Cherukuri, Buckman Laboratories
It is a pleasure to have a supplier like you
Joseba Iribar, Groupo Gusacor
NAZDAQ have been producing useful tools at value for money prices for 10 years
Ed Hubbard, Automated Packaging Systems
The B2Win software is excellent value for our money
Peter Fiebeg, Maschbinenbau Kitz
Will upgrade our Baan IVc4 environment to ERP LN and our NAZDAQ's products will make that transition with us.
Jim Pogue,DPT Laboratories