Search results

Mike, I can not seem to utilize this code. Can you give me a short example of how to send an Access report email using this code? Thank you very much for all your help and ideas.

I added the module and loaded the code. I checked the Microsoft Outlook 12.0 Object Library. I can not use the SendMessage function as an action item in a macro. Does this function only work with more code?

I'm also on Office 2007. Does the sub code run without the security warning? If so, please excuse my ignorance in this matter, but where does the sub code go? Do I keep my current macro, which runs through each record, and add this to send the email??

Before I put ClickYes Pro on my PC the access macro would progress through all records and send each store their email. It just forced me to click "allow" each time. I am using the actions SendObject and GoTo record. It worked except for the security warning. Now, for some reason, my...

I tried the ClickYes Pro and it worked to send the first email without the security warning but then it would not go to the next record and send the next email. It just stops after the first email. Any thoughts?

Is there a way to disable the Outlook security warnings so that I can send email from Access with clicking "Allow" Program to send email on my behalf?

I'll give that a try. Thanks for your help!!

I have a query that allows the users to pick a date range using the criteria Between [Enter begining Date] and [Enter Ending Date]. Is there a way to replace the box under Enter Beginning Date and Enter Ending Date with the built in DatePicker in Access 2007? Thanks for any advice!!:confused:

If I have a report that returns results for below goal, meets goal or exceeds goal is there a way to show the results as an image? For example... My report currently says Store Period 1 Period 2 Period 3 100 B C A where A=exceeds goal, B=meets...

scalextric59....thank you very much for your help! This site has always proved to be a valuable resource of knowledge. Here is the code I used... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.fmt = "A" Then Me.[1].Format = "#,##0" Me.[2].Format = "#,##0"...

Each row has a format designation of A or B based on what number format it should be with A being currency and B being percent. It looks like this... Item FormatType JAN FEB MAR Sales A 100 100 100 Margin B 50 50 50 It...

It's been a long time since I've been out to this board and I'm glad to see it's still going strong. My question.... Is there a way to use an if then statement to format numbers differently in each row of data returned in a report? For example, I have created a report that returns 25 rows...