Recent content by Johnvandamme

Great to see how technics can make people happy :)

I would open a relay form with the result in it , and refer the emailbody to the form content. if mail sent go to next record and send again.. create a loop..

put it in zip format on the forum. I think this is a relation problem.. can happen in dbase world :)

Hello, I want to create a database that will do following tasks: [LIST] Import emails Append in temp table with dump ID (dump ID contains folder where the mail was stored in) Scan the subject of the mail (find customer & ticket ID) Scan the body of the email looking for keywords : DOES NOT...

hello, thank you for your reply. That function is disabled. I will look into it.. but maybe you can help me quicker? how enable the office links function ? thx

Have a good lunch with your IT people.. and try to convince them to provide access. much easier than code above :)

the heaviest but fastest way would be this : import the csv each time name TBL_WT (worktable) perform a unmatch query with the db data append this data to the DB data Empty the TBL_WT Job done ! Good luck with it. John

or create a form with a timer event..

Hello, Add a field to your table. color : number 1 or 2 Then create a form based on your table put all fields in a columnar format (use the wizard if you are lazy) then take the color field and stretch it to the size of the form and put it to back. Add a conditional formatting: if 1 put in...

Link doesn't exist anymore (:

I have the same question....

Hello, new to this forum. short question : Is there a possibility to initiate the merge function of Word by Access. I have a table where email and content and all other stuff is stored, but this should be sent via a template that is stored in Word. OR ... Is there a possibility to...