• No Comments

Hi guys, I hope someone can help. I’m using the Outlook ject in VBA and want to attach a PDF file. Outlook only allows. DoCmd SendObject Command in Microsoft Access: Features and Limitations for The attachment can be in text, rich text, Excel, HTML, PDF and XPS formats. How do i can send email using send object and including an attachment for it. This is my module ject.

Author: Taumuro Vojora
Country: Sweden
Language: English (Spanish)
Genre: Education
Published (Last): 12 June 2004
Pages: 22
PDF File Size: 2.43 Mb
ePub File Size: 8.15 Mb
ISBN: 284-1-56951-539-1
Downloads: 55441
Price: Free* [*Free Regsitration Required]
Uploader: Nasar

The output format of the object being sent: If an object is included, this message comes after the object is displayed.

DoCmd.SendObject method (Access)

Compressed Attachments Total Access Emailer lets you compress multiple files into one zip file for faster transmission. I’ve only attached a. Messages can also be from an Access report in text or HTML format optionally filtered for each recipient. Type This is the type of the object attached to the mail. This is also to docmd.sndobject selected when there is no attachment.

Visual Basic 6 Products. A string expression containing the text you want to put on the Subject line in the mail message. What’s the easiest way to become a member and start posting?

Edit This docmd.senodbject argument denotes whether the email message can be edited before sending. I’d really appreciate some help. SendObject doesn’t support multiple attachments.


SendObject Method of MS Access | Database Solutions for Microsoft Access |

Harleyquinn For tsunami relief donations Red Flag This Post Please let us know here why this post is inappropriate. I have the same question There are no open issues. It’s easy to join and it’s free. How should I configure my browser to get the greatest benefits from the Lounge?

SendObject By rodkort in forum Access. docmd.sensobject

Sending Email from Access using Docmd.sendobject

The attachment item must first be saved externally then code will attach to an Outlook email object. If the mail application does not recognize these email addresses, the application throws an error and the mail is not sent.

To Optional Variant A string expression that lists the recipients whose names you want to put on the To line in the mail message. Here is one thread about using email object: If you leave this argument blank, the Cc line in the mail message is blank.

If you need more sophisticated emails, learn about our Total Access Emailer program. Vienna, Virginia Privacy Policy Webmaster.

Howto send TWO attachment in ject.. – Microsoft: Access Other topics – Tek-Tips

A string expression that lists the recipients whose names you want to put on the To line in the mail message. Total Access email also tracks the times each email blast was sent, the total number of messages sent, the last time it was started, and when it finished.

If you leave both the objecttype and objectname arguments blank, Microsoft Access sends a message to the electronic mail application without a database object.


The SendObject action can attach a MS Access form, table, report or query in an electronic mail message. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. The time now is I see there are Add-Ins available but only for upwards, and I’m using – any ideas? If you send a report, the only controls that are included in the object are text boxes for.

TemplateFile Optional Variant A string expression that’s the full name, including the path, of the file you want docmd.senobject use as a template for an HTML file. Sign in to give feedback. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Does Application have anything to do with Office Automation? The following example shows how to create an email message with Microsoft Outlook and display it to the user. When left blank, the cc line in the mail message is blank.

Hi Rui, you’re an absolute star. Students Click Here Join Us! What exactly are you expecting this code to do?