I need to fix the spacing for the report date. If the first and Last Name is shorter or longer the report date is not aligned in the email.
I use this to send out my email
Body = Body & (vbCrLf & rs("First Name") & " " & rs("Last Name") & vbTab) & Trim(vbTab & rs("ReportDate"))
John Doe 2/1/2014
Roger Longname 2/1/2014
Joe Doe 2/2/2014
I want the date to be left justified. Lined up under each other. Thanks.