Search results for query: *

No - it is not possible to put the report heading into the body of the message. it sends an e-mail with subject "Buy Detail Report" and attaches a PDF file named "Buy Detail Report". The heading is only in the actual PDF. I am using outlook 2007.

I have reports that I have sent to me in an e-mail which I then need to forward to vendors. The reports are e-mailed in PDF format. The subject line of the e-mail is always the same and there is no way (at this time) to change the software to change the subject line by vendor. The only way to...

They tried to implement the FISH! philosophy in our department also. But while mgmt was all for these activities, they never let up on their constant demands. Many of us were stressed out due to impossible deadlines, and then we get told "STOP WHAT YOU'RE DOING!!! Work on these puzzles!". Do...

Since you only have 272 out of 3000 I am led to ask you the following question: are you placing this IIF statement in the criteria field? If so, it needs to be placed in a new field so that you can then query on it. Hope this helps.

Never mind... made it work :) Here is what I came up with. Private Sub Command0_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim recCount As Long Dim recipient As String Dim recipsubject As String Set db = CurrentDb Set rs = db.OpenRecordset("NH CLIENTS", dbOpenDynaset)...

I have two working scripts that I need to somehow combine... Global vOfficeID As String Function OfficeID() OfficeID = vOfficeID End Function is in a module, and together with this form script Private Sub Command0_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim recCount As...

cchristi - I am trying to use BisCom / FAXCOM from Access. Just wondering if you had found a solution for this service? Some of us have the Groupwise integration, and some of us have the BisCom FAXCOM agent. As you stated - lots of manual input. want to get rid of that.

Thank you to dhookom for providing me with the clue to resolve my issue. I added recCount = DCount("[ACCESSION]", "Query1") If recCount > 0 Then DoCmd.SendObject acSendReport, "CCL", acFormatRTF, rs("E-MAIL ADDRESS"), "", "", "Daily Census Report", "testing daily census", False...

Thank you! That is exactly what I needed. I added recCount = DCount("[ACCESSION]", "Query1") If recCount > 0 Then DoCmd.SendObject acSendReport, "CCL", acFormatRTF, rs("E-MAIL ADDRESS"), "", "", "Daily Census Report", "testing daily census", False End If and it no longer sends...

Re: thread 816550 (http://www.tek-tips.com/viewthread.cfm?qid=816550&page=1) When looping through the office ID on my tables, it calls up each client. However, when there are no orders from that client, it sends a blank report to the e-mail address. How do I prevent this from happening?

Thank you so much for this thread. We are attempting to send e-mails to our clients detailing the orders for the previous day. During testing, I ended up with an empty form for the clients that did not order anything on the day. How do I prevent that?

The macro recorder will give you something like With ActiveSheet.PageSetup .PrintTitleRows = "$1:$1" .PrintTitleColumns = "" .PrintArea = "" .LeftHeader = "blah blah" .CenterHeader = "blah blah" .RightHeader = "blah blah" .LeftFooter =...

my machine at work does not have the Data,GetExternalData,CreateNewQuery feature turned on. As this is a large corp, I doubt seriously they will ever turn it on. I have a large file also - how do I do a vlookup on a closed file?

Anyone who wants the data bad enough, can get the data they want. It's like any burglary prevention system - the thieves can still get in if they want it bad enough. But, considering that a multitude of people don't know a web address from an e-mail address, some of the above methods can be...