Pseudocode to create multiple sheets in Excel

With ExcelBuf Do Begin
  SetUseInfoSheed;
  AddInfoColumn ('Company Name',False,'',True,False,False,'');
  AddInfoColumn (CompanyName,False,'',False,False,False,'');
  ClearNewRow;
  NewRow;
  AddColumn ('Sheet',False,'',True,False,False,'');
  AddColumn ('#1',False,'',True,False,False,'');
  CreateBook;
  CreateSheet('#1','Test Excel',CompanyName,UserID);
  DeleteAll(False);
  ClearNewRow;
  NewRow;
  AddColumn('Sheet',False,'',True,False,False,'');
  AddColumn('#2',False,'',True,False,False,'');
  CreateSheet('#2','Test Excel',CompanyName,UserID);
  DeleteAll(False);
  GiveUserControl;
END;

Source : http://dynamicsuser.net/forums/p/23242/120607.aspx

Navision SMTP Error

We encountered intermittent error in Navision related to SMTP Mail.

Troubleshooting steps:

1. In Windows Command, run nslookup
2. <smtp mail server name>.<company domain>. This is FQDN
3. Check if DNS Server is able to show the IP Address
4. If can't show the IP Address, try to add DNS Suffix in IPV4 and try to run Navision application again
5. If the problem persisted, try to ping <smtp mail server name> and if it's failed, most likely it's windows issue (guess...)

Resolution :
--> Change SMTP Mail Server name in Navision SMTP Mail Setup to IP address.

After quite long break.....