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.
Author: | Kizragore Malara |
Country: | Bulgaria |
Language: | English (Spanish) |
Genre: | Relationship |
Published (Last): | 23 August 2018 |
Pages: | 131 |
PDF File Size: | 2.78 Mb |
ePub File Size: | 10.37 Mb |
ISBN: | 247-7-36934-599-1 |
Downloads: | 57495 |
Price: | Free* [*Free Regsitration Required] |
Uploader: | Moogugul |
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!