Search results

WOOOW, impressive :-) Thanks a lot this, I tested and it worked so great :-) Once I have finished the whole thing, I will post the code so others can make use of it too. Greetings.

Hi, It was an error, should have been "participant_name" a typo in plain view :-( Greetings.

Hi, It looks great and works nice :-) I guess I can make my loop work when I have the Event ID in the subject, Dim it as a String and then add this with every loop to the table. The email subject has to be similar everytime and this will solve it (I hope). Greetings.

Hi, It is reall a pain to work with the code I have. I managed to make it create a record for each participant, but I can't get it to add also on the same time the Event ID. Maybe a custom outlook form would do the trick. People would fill in the fields there and submit. then I would process...

Hi, the code used to extract the text from the email is in the first post. This is the HTML table from the email: Event ID:24Participant 1: John July Participant 2: Peter Cetera Participant 3: Mister X Participant 4: John Bad Jovi Participant 5: Lukas Snow Participant 6: Claudia von Dam I...

Hi sneuberg, Thanks for your comments. The format of the email is HTML. at the bottom there is a table with 2 columns and 7 rows. The code is created like this in another automation: Private Sub btn_enrol_email_Click() Dim objItem As Object Dim db As DAO.Database Dim MailList As...

Hi all, I created some code to read emails from Outlook and put text from a table in the email to the Access database. Now I need to capture the participants from the email and create for each a new entry in the database. It would need to go one by one of the participants name and add themm to...

Hi all, I managed to solve it, it was not easy..... Just for the ones that would like to use the soluion: Private Sub btn_process_enrolment_emails_Click() '//--------- Dim and Set------------------------ Dim TempRst As DAO.Recordset Dim rst As DAO.Recordset Dim db...

Hi all, I made in the past a macro that would scan emails in outlook and if they had a particular subject, then the body would be scanned and the text passed to excel workbook. Now I try to alter the code to make it pass it to the access database. I did many things, but this one is a harder...

Hi all, Closing this as it seems there is no solution possible for this. Greetings.

Hi all, No possible solution? Greetings.

Hi all, I created a form that has unbound text boxes that will hold the information to create an invitation in Outlook. I have almost everything working, the only thing I still have problems is with getting the attendees from a subform in datasheet form. I have the below code: Private Sub...

Hi Galaxiom, I actually solved by adding a new query with the extra CTB in it. This is now run from a second button to call up the query. It works great, maybe not an elegant solution, but still great. Greetings.

Hi all, I have a query that will add a case to some one that can do the quality check on some one else data. there are 8 fields in the query. There is the field "sent_for_check_first_time_date" with criteria "Is Not Null" second ond that needs criteria is "final_checker_name" this one has to be...

Hi Ranman256, I still had no time to check this out, once I will be able to concentrate on it, I will let you know the outcome. Greetings.

Hi all, I have some code to create email and add data from fields into the subject and body. What I would like to know if it is possible to save the email generated direct into a folder in the disk. Any ideas how to get this done? Greetings.

hi Sneuberg, I wass a few days absent. I will try this out and post back. Greetings.

Hi all, It seems that finding information on how to show a word document inside a web browser control in a form is a hard thing to do. I tried the below, but it just opens in a word window instead of the web browser objct in the form. Any clues where I go wrong? Private Sub...

hi Static, Thanks, it is a good one :-) Just wonder how to add it to the SQL. Will have a few try outs to see what I get. Greetings.

Hi Minty, I need to put them in the clipboard to use them on a word document. I still need to figure out the textboxes in the word document as they are not clear to me right now. In future I could make access write it straight to word. the most silly one to solve is the "#" thing. Greetings.