Site Overlay


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.

  BGI 5027 PDF

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!