Search results

I've now almost got it done, completely rewritten... however, needs some error handling in it. If I cancel the email rather than sending it, it returns the message "Message sent successfully" - what can be put in that would trap the email not being sent and return a message saying "Operation...

Awesome Paul, works like a charm. With the DoCmd.SendObject, do you know if the email that is generated can be set to HTML? Also, I notice that the signature does not show up with this generated email. Is it possible to have that displayed or is that a lack of functionality with the...

Since you've been so helpful, how can I end a message that say's it's completed successfully at the end of the script? E.g. MsgBox "Operation completed successfully"

Don't worry, I sorted it, just added then after If Err.Number <> 2501 then Thank you for your help Paul, used that link you sent to find the info. Good stuff

Hi Paul, I added as shown however when I run there's a syntax error on this line: If Err.Number <> 2501 Also Compile Error, Expected: Then or GoTo What needs to be added where? Thanks

Hi, I'm inserting a report based on the current open record into Outlook email. It all works fine except for a couple of things. If the email is cancelled, an error displays along with the report being left open - due to debugging. (Run-time error '2501': The SendObject action was cancelled)...

Thank you for your help here Paul. I've written the following code. DoCmd.OpenReport "nonconformity", acViewPreview, , "[nonconformid] =" & Me.NonConformID DoCmd.SendObject acSendReport, , acFormatPDF Now if I cancel the Email it pops up with the following error: Run-time error '2501': the...

Also, how do I bold the underlined part of this line: & vbCrLf & "Description of Issue: " & Me.Issue_Description & vbCrLf & vbCrLf...

I see what you mean,... so if I've got my DoCmd.OpenReport set to the following: DoCmd.OpenReport "nonconformity", acViewPreview, , "[nonconformid] =" & Me.NonConformID How do I use the DoCmd.SendObject to pick that open report in preview mode and place it into the email? I'd like to try...

Sorry I'm a complete novice. I have no idea how to begin writing this. Where in the following text does SendObject get placed and how do I complete the wherecondition? - I don't want to be saving any pdf to file location but rather straight from report preview to email. DoCmd.OpenReport...

That's very helpful, but how do I get a report in print preview, generated from this code as an attachment at the same time? Private Sub Command25_Click() DoCmd.OpenReport "nonconformity", acViewPreview, , "[nonconformid] =" & Me.NonConformID End Sub Also, if I was going to change the body...

Brilliant, now how to get normal default signature to display. With current code it just sets up a blank email without default user signature.

Hi Alan I looked at the code but I don't want it to email right away. I want the report that is generated by the code above to become an attachment to a 'New Mail Message' (using Outlook) and for the email to remain open so some user defined data can be entered into the body. Does that make sense?

I have the following vba that takes current data off a form and puts it into a report: Private Sub Command25_Click() DoCmd.OpenReport "nonconformity", acViewPreview, , "[nonconformid]=" & Me.NonConformID End Sub I want to take that report and have it attached to an email as pdf doc. Also...

Hi, I want to do a similar thing of only reporting on the current record that is showing in the open form. If I use a macro to drive the sendobject (Access 07) to send the pdf to the email address current on the form, how do I get the vba to run the report for the 'current' record on the form...

How can this 'print' button be taken one step further and attach the report (current record of form) as a pdf grabing the email address off the form too??? I have little access experience and could give the name of the fields & form if that would help