Recent content by hooby1

  1. H

    Solved Finding names from table of not duplicated rows

    Hi all. Many thanks for all the replies. I will have a look at each one and see how I get on. It certainly does look like the queries will be the ones I require. Thank you so much for all your help and assistance.
  2. H

    Solved Finding names from table of not duplicated rows

    Please ignore the properties of the way the table is set up as this is a simple broken down copy and sample data of the table I am using to show as an example. Is it possible to run a query to show the following: I want to know any names who have done "FirstAid 2" and / or "FirstAidOS2" but...
  3. H

    Form to send email (email blast)

    pbaldy.... so you did. Apologies on that I should have clicked back and seen who did post it. Many thanks.
  4. H

    Form to send email (email blast)

    Hi pbaldy. Many thanks for the reply. I see what you mean now. The only thing I need is to somehow put a delay or a pause in the loop so it doesn't appear I am a spammer sending loads of messages out at once. Say 10 messages every 1 hour. There about 50 messages in total. I think here is a post...
  5. H

    Form to send email (email blast)

    Hi pbaldy. Thanks for the reply. When you say the spreadsheet is an unnecessary step, unless you need them there for other purposes. - The contacts will always change and never be the same so it really is button that just will open a query to show the contacts that it will go to. Some macro will...
  6. H

    Form to send email (email blast)

    Hi CJ_London. Starting from the very beginning and re-reading the code I made a fresh copy. I have them copied your code and changed the lines I had to and now it works! Finally I can send an email from a click of a button. (Start with one email address like you say and work from there) The...
  7. H

    Form to send email (email blast)

    Then im confused now as you said I am missing some code from the example but I copied it from the gmail module and took out the comments that I needed to starting with the ' lines and entered the personal information I needed to use. See above. If I have copied the gmail code and it still errors...
  8. H

    Form to send email (email blast)

    Just to confirm that a ' is a comment line? Is a . one as well? So i make .item.... now item... and it should work?
  9. H

    Form to send email (email blast)

    Hi CJ_London. Thanks for the reply. I have re-downloaded the example and opened the code from the gmail module and I cannot see where I am missing the code. I don't understand? There is nothing missing in front of the .item in the example code from that website. I have followed the instructions...
  10. H

    Form to send email (email blast)

    Hi CJ_London. Many thanks for the help so far. Much appreciation. Here is the code taken from the website and now edited for sharing purposes. Below the code is the error message I am getting. Option Compare Database Private Sub Command0_Click() 'If you have a GMail account then you can try...
  11. H

    Form to send email (email blast)

    Hi CJ_London. Many thanks for your help on this. So far I have started again with the form so all there is a button that says send email and I have right clicked > Properties and on the "onclick" event I have added the code under the "Event Procedure" and entered the code on the VBA screen. From...
  12. H

    Form to send email (email blast)

    Thanks for the replies. When you say "Perhaps if you provided your attempt we can suggest where you are going wrong" The screenshot in the first message is the latest I have. I have no code behind it. After looking at the website given I am still struggling to understand it sorry. Is it possible...
  13. H

    Form to send email (email blast)

    Is it possible to have a form that when the user clicks on a button it looks up a column in a table of email addresses and sends the email without the use of Outlook or other email applications? I am after a form that when the user inputs in fields e.g. subject, the message itself and then...
  14. H

    Calculating total number of hours worked

    Many thanks for the help. After making changes and a few modifications it now works. Many thanks.
  15. H

    Calculating total number of hours worked

    Andy_25, I have the week's hours in but I would then like a grand total of the hours worked for that week. Your way only calculated the last inputted entry.
Back
Top Bottom