Functions like vbcrlf?

[BaudKarma]

I'm building a program to track promotions within our company. One of the requested functions is for the program to automagically send an EMail to payroll when HR has recieved all of the paperwork necessary to approve the promotion.

I've got the code to compose and send the EMail completed. I build the body of the email by using a text string called strEmailbody, and just appending the necessary data and filler text to it. For example,

strEmail = "Employee ID: " & me!eeid & vbcrlf & "Employee Name: " & me!name... etc etc

The problem is that the body of the email looks a little ragged. I'd like some way to line up the columns of data nice and neat, but I don't know how to do it. Is there a vbTab function or something similar I could use? Or a different way to compose the body of the email? I'm using the docmd.sendobject command to send the Email via Outlook.

 

[smedvid]

You can use the VBTab also to add some structure...

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[BuilderSpec]

Hi

Why don't you create a good looking report in Access that has all the layout you want and the employee details on.. then in the code simply use the

DoCmd.SendObject

function to send the report as an email? Then the email is formatted how you want.

Regards



Hope this helps!

Regards

BuilderSpec