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!