Formatting recordset data into an email

[Moose3]

Hey Everybody,

Does anyone know what the correct VBA syntax is to start columns at a certain field number? I know when using Debug.Print its Tab(24) to start at line 24. But it gives me an error when exporting a recordset into an email.

Here is a subset of my string:

strLtrContent = strLtrContent & vbNewLine & rsComplete![Project#] & "-" & rsComplete![Detail]

Where the "-" is shown, is where I want to be able to start that column of data at a certain spot and keep all my fields lined up.

Thanks!!!

 

[LPurvis]

The formatting you require will need HTML content in the email (you could perhaps hack it into submission with a fixed width font - but it would't be my preference personally.
Have a look at this thread for some suggestions and a link perhaps.
http://www.access-programmers.co.uk/forums/showthread.php?t=191736

Cheers.