Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


Aligning Text in a String for use in an EMail


Aligning Text in a String for use in an EMail

Author
Message
BenjiB
BenjiB
Forum God
Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)Forum God (680 reputation)

Group: Forum Members
Posts: 2, Visits: 3
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?

GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search