Search results

I need code line that will Request Delivery Report in Outlook 2010. I know about ReadReceiptRequested reference and that is not what I need as it tigers "Request a Read Receipt" checkbox in Outlook 2010. I need a code that will check "Request a Delivery Receipt" box!

I need to use HTML template file as body in emails. The emails will be sent via Outlook 2010. The code I made is working well with .oft files, but these files are being received as plain text, although they are sent as HTML and although they appear fine in sent box. After googling, I found that...

It's working now. Thank you!!!

I need a query that should filter null records in text field. If I set IsNull criteria, it is returning 0 records. If Not IsNull is set, it returns only records with data in the field - as it should. I have checked if the value of empty field is null by opening recordset and trying to present...

Thank you my friend!!! That is what I needed!

:( Error message I attached the file with query and table.

Would you be so kind to give me quick solution on this one. I am not that familiar with functions you mention and having a time pressure. I would very much appreciate if you could provide actual example for this case. SELECT DISTINCTROW Partition([broj],1,500,5) AS Range, Count(Test.broj) AS...

I don't know how to filter it later... The plan was to make another query that will filter just one group with 5 rec. The loop would then go group by group and send mail by mail. With partition, I get groups and that is very nice. But, I don't know how to filter just one group. It returns 1:5...

...technicalities :rolleyes: :) Step up, but still not solution... The table will contain several hundreds of email addresses which should be sent 5 at a time. I was hoping to group all records from the table at groups of five and to assign increment value to each group. Records 1-5 group 1...

Tks vbaInet! It looks as if this could be the solution. Unfortunately, I get "Data type mismatch in criteria expression" error message. SELECT DISTINCTROW Partition([NazivFirme], 0, 50, 5) AS Range, Count(Klijenti.NazivFirme) AS [Count] FROM Klijenti GROUP BY Partition([NazivFirme], 0, 50...

Currently the table is empty as in production faze. As I have only several records now, presenting actual table would not be helpful. Once table is filled with data, it would have between 500-1000 records. In case it is 500 records and I want to have interval at every 5 records, I would need...

I have table with customer information that includes email addresses. I want to use that information to send emails to number of addresses at once. Due to ISP restriction, only certain amount of emails can be sent per x time. Therefore, I must send emails at groups of 3 for example. I need to...

I need to create a query that groups records at certain interval, every x records. How can this be done? Tks...

Tks David for prompt response. I managed to try simpler solution, simpler for me at least... :) http://www.access-programmers.co.uk/forums/showthread.php?t=156665

Basically, that is the question. After data entry, and saving procedure I need to get the ID for that entry. Private Sub dgmPotvrdi_Click() Dim db As Database Dim rs As Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("klijenti", dbOpenDynaset) rs.AddNew...

Try this... http://www.access-programmers.co.uk/forums/showthread.php?t=205498&highlight=drag+drop or http://www.access-programmers.co.uk/forums/showthread.php?t=205498&highlight=drag+drop Enjoy

This is all I need now. Thanks guys!!! However, I do not understand how to: Could you please explain how to add multiple addresses to the BCC?

Fixed it. Location of the file on the subject computer was C:\Program Files (x86)\Common Files\microsoft shared\DAO. I made another location (as on other computer, where all this worked) C:\Program Files\Common Files\Microsoft Shared\DAO and it worked. I had to add directory DAO as it did not...

I need to activate dao360.dll file, Microsoft DAO 3.6 Object Library, on the list of references. I have it in the list and when I click to activate it, it informs me that there was an "error in loading DLL". Please if anyone can help, I need to fix this problem by tomorrow afternoon latest...

... and here is the link to that post http://www.access-programmers.co.uk/forums/showthread.php?t=204294&highlight=custom+toolbar+in+access+2010