outlook automation

[ERIC PAUKEN]

developed a db using 2002 access in 2000 format. using DAO I get a
recordset that is the basis of an email message body. one of the fields
(ItemDescript) can vary in length. I am having trouble getting the
subsequent fields (OnHand, ReOrderPt) to lineup so that they are in one
column down the msg body. any suggestions to point me in the right direction
would be appreciated.

thanks in advance

 

[Arvin Meyer]

Try using a tab character. Chr(9)

Access will not recognize it in a memo field or text field, but VB/VBA
recognize it when writing data directly to a text file.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[ERIC PAUKEN]

thanks for the reply.
I was using chr(9) and I tried assigning the query field to fixed width
string varible and then concantenting the variable to the msg body and then
using the tab character to space over but it is inconsistant still.