SendObject Command in Microsoft Access using VBA or macros and how Total ject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc. The SendObject action can attach a MS Access form, table, report or query in an electronic mail ject acSendTable, “emp_mast”, acFormatXLS, . ject in MS Access database Docmd SendObject sample code and SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject.
|Published (Last):||23 August 2018|
|PDF File Size:||2.78 Mb|
|ePub File Size:||10.37 Mb|
|Price:||Free* [*Free Regsitration Required]|
Search this forum only?
Message will auto close in 2 seconds. Sendobject Output FormatOffice Jan 5 Hi, I have pretty simple code to send a report via Outlook.
ject method (Access) | Microsoft Docs
SendObject acReport, “name”, “here is my problem”,”subject” The output format – I can’t output to Excel? Anything but Excel, when I try “Microsoft Excel. In you can send docmd.semdobject Excel format xls in use xlsx.
I tried the acFormatXLS before, didn’t work. SendObject acReport, “name”, “Temp1.
I thought you might try in the “TO” section just sending it to a blank spreadsheet attached to an email, but it has been a long time since I tried that so I am not sure it will work. Looks like you had it reversed Outputformatt 6 AHHH, why is this so difficult?!!
This is what it should look like to send in a predefined template: Still getting the Error: Not seen this message with Accessat least not that I recall. I don’t want to ask too much of you, but can you explain why that worked?
Light bulb when off And not until I actually opened it did I remember that!. GinaWhipp View Member Profile. MiltonPurdy View Member Profile. And not until I actually opened it did I remember that!