Search results for query: *

I have a few questions regarding the above code: Do I have to export the reports? Is "Attachment" the name of the report?

Thank you both very much. However, due to time constraints, I am going to have to create the reports as outfiles and have the user e-mail each one individually. Hopefully, I will be able to get back to this project and learn from your code. Thanks again, Anne

Thank you both very much. Wow! I am very green regarding this depth of code. In my little world. I had created a table of company codes and e-mail addresses. The report would run for each company code and e-mail the corresponding address from the table. This code was created by converting a...

Thanks Leslie, any help is greatly appreciated!! Code is as follows: DoCmd.RunSQL "SELECT [z shell to create outfile by dealer].* INTO [outfile for report] FROM [z shell to create outfile by dealer] WHERE ((([z shell to create outfile by dealer].DEALER)= '" & vOfficeID & "'))", -1...

Created an attachment for e-mail using rtf. Lotus Notes is launched to send the e-mail and the attachment appears with .xls as format. Before I sent the document I opened it and it was is a mess. Please advise

The sql creates a table, outfile for report. This table only has one company(dealer in my case) and is used as the record source for my report. Please find below the entire event procedure. Hope this helps. Anne Dim db As DAO.Database Dim rs As DAO.Recordset Dim eml As String Dim vOfficeID...

Bob, Thanks for your response. I was able to resolve my issue with the following query. DoCmd.RunSQL "SELECT [z shell to create outfile by dealer].* INTO [outfile for report] FROM [z shell to create outfile by dealer] WHERE ((([z shell to create outfile by dealer].DEALER)= '" & vOfficeID &...

Bob, Thank you for the valuable information. I was able to create the e-mails, however, the entire report is being sent to each individual in the tbloffice table. The original record source for my report is a query that prompted the user to select a company to view that report. I removed the...