Topics Search

SendObject not working first record.

SendObject not working first record.
Views: 1
im sure this is something very simple but I cant work out whats wrong.

I am very new to access, I have a form that on Load runs the GoToRecord macro and selects new which should mean im ready to enter a record, at the end is a button to email that record to whichever department needs it. my problem is if you open the form and fill out the data, the email attachment is always blank just with the field names, if you go back into the form and actually click the new record button and fill it out it all works fine
Sponsored Links:

Similar posts...


Quick Q about SendObject

Quick Q about SendObject Icon
Can anyone please tell me how I go about using the SendObject command?

Where do I put the following syntax and how do I link it to a command button on my form?

DoCmd.SendObject [type][, name][, format][, to][, cc][, bcc][, subject][, body][, edit][, template_file]

I've been reading up on it for the past 90 mins to no avail

SendObject - Change from address

SendObject - Change from address Icon
I am using SendObject in a database :-

DoCmd.SendObject acReport, stDocName, acFormatPDF, COUemail, , , subject1, "Please see attached a new Carriage Forward Request"

The email works fine but when it opens it automatically gives the users email address as the 'From', I want to put in a different one.

This works in MailModule.SendEmail, but can I get it work in SendObject?

SendObj - working, but can it do this?

SendObj - working, but can it do this? Icon
I have nocked up a button to send an email with the information gatherd from the record. is it possible to set the emails flag date-due for the person while the email is sent?

the email is sent using the SendObject command

Sendobject for email

Sendobject for email Icon
Where can I get a document that explains how to use SendObject to send emails from Access?

sendobject acsendreport

sendobject acsendreport Icon
Can anyone provide me with an example/syntax of the sendobject command where it uses a template

Emailing a PDF of report but non lossy PDF?

Emailing a PDF of report but non lossy PDF? Icon
I have a Macro that emails a PDF using the SendObject command, but the PDF attached always loses some quality on the images within it. I have Googled about this and found that there is a setting called acExportQualityPrint and acExportQualityScreen.

Its seems acExportQualityScreen is the default on SendObject though. Is there any way to change this? I see there is this option when you do a OutputTo command, but not on SendObject command.

SendObject Outlook template

SendObject Outlook template Icon
I have a Template email message saved as an HTML file that I would like a SendObject macro to use when it opens a new email message.

In the SendObject macro, I have typed the following in the Template File argument:
"C:\Documents and Settings\cimbrie\AA Database\Invoice test Template_files".

I have tested the link by clicking on it in Word and it takes me to the AA Database folder and selects the file. I interpret that to mean the path is right.

The SendObject does not open the template. It just opens a new email.

error 2501 The SendObject was cancelled

error 2501 The SendObject was cancelled Icon
I have a button that opens outlook and puts the forms email address in, click send and everything is good. If I close the email without sending it gives me a runtime error 2501 The SendObject was cancelled. It's only a problem if I do not send an email.

Private Sub txtemail_Click()
DoCmd.SendObject acSendNoObject, , , emailtxt, , True

SendObject - Object already uploaded to access as an attachment

SendObject - Object already uploaded to access as an attachment Icon
A PDF document that I have already uploaded to access and appended to the record I'm currently viewing.

So what's the problem?

I can't find a way to attach a document I have uploaded to access. I'm not even certain sendobject supports that.

SendObject - Snapshot format

SendObject - Snapshot format Icon
I'm looking to e-mail a report (from a button on a form), but would like to send it in Snapshot format (or pdf as we've got CutePDF), but I'm struggling to find the appropriate syntax for the SendObject command.

This is how far I've got;

stDocName = "rptSIR"
DoCmd.SendObject acReport, stDocName,

I knowit's the next part, but what?