Search results

Yes, the button (Command) is on the report and now on a form. It is named EmailEstimate. Here is its VBA code on Click() Private Sub EmailEstimate_Click() On Error GoTo EmailEstimate_Click_Err Dim strToEmailAddress As String Dim strCcEmailAddress As String Dim strLastName As String...

Changed it so that I would have the command and VBA code on a form that has all the same fields as the report I was using. Still the email attachment is listed as {Numbers}.dat. Don't know what I am doing wrong. If there is code I can use to manipulate the Attachment File Name, this would be...

Again, I did just start using this forum today. The first post came under introduction before I realized how it would post. Then the second was my attempt to correct it. Only to discover that I should have changed the title. The use of poor etiquette should be reserved to scold those who know...

I am sending from a report in report view and not a form. However, I can change this if that is this reason why it is not working.

Not sure why I received your email, I know I was new at this today. Are you just informing me that I have posted a thread more than once and are there complications with this?

Yes, The Report Caption is Estimate but I also have a Field on the Report called [Title]. In the Reports Query named EstimateReport, [Title] is set to equal "Estimate" The Report also has Field Names [LastName] & [EID] (The Estimate Number)

1. EstimateBHRPrint1 is the real report (This is the report that is open in report view when I click the commend198 to run VBA code) 2. I currently use Access 2010 (System displays 2007-2010) 3. I would love to have the Attachment Named "Estimate" & "EstimateID" & "LastName". I have tried some...

Attachment File Name as it appears in email attachment box {F54EBDF9-B9B6-4EA1-B56D35DEC50D0F69}.dat (257KB) When you select open it does retreive the file in PDF However, our customers are not very likely to open it because of its File Name. I do send the document to PDF file 1st Please...

Changed TRUE to False Attachment File Name as it appears in email attachment box {F54EBDF9-B9B6-4EA1-B56D35DEC50D0F69}.dat (257KB) When you select open it does retreive the file in PDF However, our customers are not very likely to open it because of its File Name. I do send the document...

DoCmd.SendObject acSendReport, "Estimate", acFormatPDF, strToEmailAddress, , , _ "Issues Report", "Issues Report is attached", True

I am not sure what to expect for a turn around on an Access Question Does this work and how patient should I be?

First and Foremost, 1st time and 1st post I am a business owner with a wife who loves to help out. I want to make it easier for her to send a report via email in PDF format. I've been able to do this and the Email Attachment is a PDf. The Problem Is! The Email Attachment makes no sense to...

First and Foremost, 1st time and 1st post I am a small business owner with a wife who loves to help out. I want to make it easier for her to send a report via email in PDF format. I've been able to do this and the Email Attachment is a PDf. The Problem Is! The Email Attachment makes no...