Send Object command

[accessfever]

I have a simple SendObject comand to send a table to an email address. It works except the email "To" section has the same email address duplicated and one blank line in between. The focus is shifted to the 1st letter of the blank line. I tried the "CC" and "BCC" and the same problem happens.

Example:

1st line: name@mail.com
2nd line: blank
3rd line: name@mail.com

SendObject:Table, Tbl Potential Qty Issue, HTML (*.htm; *.html), name@yahoo.com, , , PIR potential qty issue, , Yes,

Any idea?

 

[vbaInet]

Are you talking about the command in a macro or in vba?

How is your To string built?

 

[accessfever]

It's in a Macro. The To is an option built in the Objectsend.

 

[vbaInet]

I don't really use macros and I would doubt if most people do but it has its uses.

This topic has been covered many times on here. Have a look at these threads and you will find something that helps:
http://www.access-programmers.co.uk/forums/search.php?searchid=6308031