Search results

you are spot on, I just came to the came conclusion. As usual hoping someone had thought of an easy way out. Thanks

Hello, I am designing a website using an access database as a backend, and have come up with this problem. Table 1: Data with a CategoryID Referencing Table 2 Table 2: CategoryID; Category Some of the Table 1 data references several categories in Table 2, If I can setup multiple referenced to...

ok its working, bit rough but does the job. I am using ExpressClickYes to geet around the click to send from outlook issue. Code as follows: Public Function SendEMail(myRS As String) '?SendEMail("qry_newsletter_email") Dim DB As DAO.Database Dim MailList As DAO.Recordset Dim MyOutlook As...

please disregard above posts mess, have sorted it out. You were spot on with the object needing to be within each pass. Will post it as soon as its tidied up. Thanks again

as follows Dim DB As DAO.Database Dim MailList As DAO.Recordset Dim MyOutlook As Outlook.Application Dim MyMail As Outlook.MailItem Dim Subjectline As String Dim BodyFile As String Dim MyBCC, secAddress, secName As String Dim myAttachment As Variant Dim totalEmails, myGroup, myBatch, myCount...

paul, Loop went in and tested.... but sorry to be a hassle, during the test phase, I used .display instead of .send it pops up only 2 emails, one from the loop and one from the remainder. There is a total of 164 emails it the test db. Is this a normal occurance for display or am I missing...

Paul, Worked a treat, only alteration was I had to set the primary variable to 1 instead of 0. Only have to change the Debug.Print MyBCC to point to my mail routine and all is great. Thank you. amended code: '?Test("qry_newsletter_email") Dim DB As DAO.Database Dim MailList As DAO.Recordset Dim...

nice n simple, will give it a go and post the results if all ok. Typical I went for the overkill approach. Thanks

Yes, I know the "For myCount = 1 To myBatch" is the problem but damned if I can see the way round. You suggest a do loop to handle count but how would you handle the check for the remainder, less than the "myBatch = 20"? All help is greatly appreciated.

Hello all, been a regular visitor but never got around to signing up. Ok, heres my issue, have written code to mail out, no probs, but to get around ips limitations I have decided to send them in batches. The loop is giving ne a headache, I know its obvious but am missing it, keep getting an eof...