SendObject - Attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learning_codes@hotmail.com - 29 May 2008 23:23 GMT

Hi,

I want to know if there is a way to copy the mde and make an
attachment to send.

Docmd.SendObject
acTable,"Table1","MicrosoftExcelBiff8(*.xls)","email@hotmail","","","Subject","Body
Text",True,""

I want to replace acTable to Access Database to send a message with an
attachment (Access Database *.mde).

Your help would be much appreciated.

Thanks.

Reply to this Message

Rick Brandt - 30 May 2008 01:17 GMT

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks.

Not possible with SendObject. You would have to use OLE Automation against
an external messaging library like Outlook or CDO.

Even when doing that if you want the attachment to be a copy of the same
file that is running the code, then it is either not possible or at least
ill-advised. Copying an Access file that is in use can result in a copy
that is corrupted.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Pete D. - 30 May 2008 01:30 GMT

Curious, why not just send the changes, tables instead of a whole datafile?
Seems like a large waste of bandwidth unless your sending like a catalog of
products. In that case move to your email program and have it send the
file.

>> Hi,
>>
[quoted text clipped - 19 lines]
> ill-advised. Copying an Access file that is in use can result in a copy
> that is corrupted.

Reply to this Message