Search results

Like so? DoCmd.CloseReport acReport, "REPORT_NAME", acSaveNo

This will make you laugh...or cringe. What's the close command? LOL!

How do I do it without open and closing the report? I get it, if I keep it this way, I need to close the report just before the end of the loop.

How does this look? Option Compare Database Option Explicit Sub SendMessages(Optional AttachmentPath) Dim MyDB As Database Dim MyRS As Recordset Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach...

Could you insert this action into the code I've posted?

Ok, back the truck up for a second. That went over my head a little bit, LOL! How do I structure the open report event? I understand I need to change the names of things, I just post the code in generals for security reasons. I was thinking of using a form to control the filter on the...

Ok, this is what I have so far. I'm a little unclear on how to implement the filter on the report. I just copied and pasted the code from the site you referenced into the script below. Option Compare Database Option Explicit Sub SendMessages(Optional AttachmentPath) Dim MyDB As Database...

Okay, I'm working on putting this in the script to output the file. I chose to use the DoCmd.OutputTo method. How do I put a custom name on the output file? I've tried doing this in the past, but haven't been able to succesfully implement it. I'd like to insert the current date and a field from...

Would the Forms!FormName.TextboxName = MyRS!FieldName be put after the "Do Until MyRS.EOF" line?

Email sent...

I really want to post the code so you can show me where to insert those commands. The forum keeps telling me that I can't post email addresses, but my code doesn't contain any emails, I've removed all personal information. 3 more to go!

Melancholy...I had my divorce papers notorized over my lunch break.

Would I be able to use a filter on the report (see below) when using the SendObject command? Me.Filter = "ShipmentsID=" & Forms![Select Load List]![LoadID] Me.FilterOn = True I'll post the code I've put together already, as soon as the forum allows me...I have to reach 10 posts before I can.

Thanks! I'm excited to learn more about MS Access!

Thanks for the reply. I was able to get the email to work, but how do I incorporate the creation of the customized report as the attachment? I'm trying to post the code I've put together so far, but for some reason the forum won't let me do it because it says it contains email...

I've been searching for an answer to my problem for a few days now, and I haven't come up with anything that will work for my needs...it may not even be possible. What I'd like to do is to write a VBA script that emails a report of potential customer leads to our 10 regional offices in...

Hello, I've been using this forum for quite some time to get tips on writing VBA scripts for my job. I've finally ran into a situation that I cannot find the specific answer, so I decided that I should probably just join the forum and post my question, LOL! Thanks to all that have contributed...