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:

More topics

 

Quick Q about SendObject

Preview
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

Preview
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?

Preview
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

Preview
Where can I get a document that explains how to use SendObject to send emails from Access?
 

sendobject acsendreport

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

sendobject acsendreport

Preview
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?

Preview
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

Preview
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.
 

SendObject with dynamic attachment name

Preview
- I am attempting to send a PDF of a report via email and the SendObject function but I don't know how to create the attachment with a dynamic name. What happens is the name of thereport gets passed to the name of the attachment.

DoCmd.SendObject acSendReport, "rpt_Certificate", acFormatPDF, "replace.me@domain.com", , , Subject, Body, Yes, ""

Something similar to this:
 

error 2501 The SendObject was cancelled

Preview
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