Recent content by CurtP

So this was obviously prior existing code. When I say render, I mean when we send out excel attachments and generate the dtstribution lists within the outlook window, these values are unable to render to find the employee, which causses the outlook window to be hung up with a pop up and not...

Hey, just gave it a shot. Same thing. It printed all the bad email values to the immediate window, but gave me an immediate System resource error when I ran the db execute.. The function checkAllEmails returns a string value (or is supposed to), but im wondering if the line checkAllEmails =...

Im thinking the error really is a data mismatch type as my access table is set up for Short Text type data. I tried setting objOutlookRecip.Name to CStr(objOutlookRecip.Name) with no success :(

Hi, I am working on a function to identify outlook email recipients that wont render, and put them into a table. I am new to VBA, and know how to simply insert records into a table. But this kind of variable is getting me stuck. The variable .To contains the whole list of "email recipients"...

Hi everyone, I'm Curt and I'm from Charlotte, NC. Worked a bit with sql as an info sec analyst at a bank and after a job switch, I find myself working primarily with access. Trying my best to learn to program in vba, but, frankly, I'm on a team with not much help on that front so here I am. I...