a graphic box in the subject line of E-Mail sent from Module

[Joe Blow]

Hello All:

I created a macro to automatically E-Mail a table every morning.
I converted the macro to a module and modified it.

I wanted the date to appear at the end of the subject line.

ldate = Format(Date,"Short Date")

On the line:
DoCmd.SendObject acTable etc...

for the Subject field I do : "Daily report for " & ldate
Should produce the result : Daily Report for 08-10-05

Sometimes I get a box which turns out to be chr$(02) at the end of the
subject line after the date... What's weird is that it doesn't happen for
all the tables... just *some*.

Any ideas?


Joe

 

[Joe Blow]

Can someone take a stab at this, please ???

Thanks,


Joe