Recent content by Luchi

Thank you ever so much all!!! Very helpfull! I'll get working on it today... not sure I'll grasp it all as I'm really new to VBA, but I'm eager to learn it :) I'll inform on here how it all went.

correct :) and in layman's terms, I want: From a data set, send all records that concern a spesific responsible to that person. Basically I want to have a way to run a Macro or VBA that will open up a table/query that has a list of information that I want to run a Query on. Once I get the...

Hi there, I have been trying to solve a "problem" and found the following answer on an other Forum to exactly my question / problem. But I would really need an example of such a vba code to open a recordset example code... Does anyone have something similar handy? Ideal would also be with the...

ah :) perfect! thank you ;)

Hallo sonic8, vielen Dank! I have been looking at your turtorial and advice, but I seem to be getting something wrong... I keep geting an error message: Laufzeitfehler 3075: Syntaxfehler (fehlender Operator) in Abfrageausdruck 'Email Ansprechpartner'. Here is the code I have so far :)...

Danke ;) war auf deiner Webseite, super! Unfortunatly I guss I'm doing something wrong here... I Keep getting an error message when I try to run it (test run): Laufzeitfehler 3075 (fehlender Operator) in Abfrageausdruck 'Email Ansprechpartner' The full code ist here: (step one ;) ) Option...

Thank you sonic8 :) in the mean time I created a query, that pulls all the data that I do need and also need to query. I now added a query that pulls me only a list of names (mails) from that query. That should work to no? If I take that query now as a Recordset in VBA. Would you have a...

Hi, I faced with a rather basic question on how to build what I want to buld in the most effective way... thought of several methods, but I'm always supprised of all the littel "tricks" (things I didn't know could be done that simple), I find on here and thoughts I would ask this time prior to...