I have a system designed arounf Outlook 2007 using VB6. The system generates Email Confirmations to the clients which involve listing the products that they have purchased, e.g. Description Qty Price Order Discounts Order Total Product 1 1 12.39 No discounts on this item 12.39 Product 2 1 9.27 10% Discount Applied 9.27 etc etc etc. This string is built up from a dataset using a combination of padded strings, e.g. ProdDesc = Format(DatasetValue, "!@@@@@@@@@@@@@@@@@@@") ProdPrice = Format(DatasetValue, "@@@@@@@") etc etc Email string = ProdDesc & ProdPrice ..... & vbcr I end up with a string which does not line up. I have also tried using fixed strings with vbtab but this also doe not always line up. Anyone got any other ideas?
|