copy from fields to single text field

[Tpaairman]

I have a check register DB with several layouts. One of these is the actual register where the transactions are entered and it keeps a running total. What I want to do is this.

Each week when the bills are done, and hence new transactions have been entered since last week, I want it to send an email statement with the new transactions since the last statement was sent.

In the register I have a field called EM and when a transaction is entered (hence a new record created) that field is auto-entered to be "N". This part of my script I have pretty well figured out. I have it start from the top and look for the first record with an N. I then want it to copy the date, item number, description and amount to I guess a text field in another layout?? that would then get emailed.

Something along those lines. Here's where I'm running into an issue. I have a similar script for archiving old transactions. It looks for anything more than one year old, and I have a layout where it pastes them into one text field. It works perfectly fine, except the text gets out of alignment since the contents of the text are not all a standard size.

In other words, because the descriptions are all different lengths, everything after that does not line up with the row above, so it looks something like this:

8/15/09 -- #123 -- Electric Bill -- $25

8/15/09 -- #124 -- Water Bill -- $30

I'd like for it to be in lined columns.