Recent content by jimday1982

Thanks for your reply - I should have specified I was using Outlook EXPRESS and I found a security setting in it that I could turn off (Warn me when programs send e-mail as me) that fixed the problem.

I have a function that sends about 15 emails but everytime it sends one, the user has to click an ok button because for each message being sent, a msgbox comes up that says "a program is trying to send an email using outlook - do you want to continue?" - Please tell me there is a way to bypass...

Well how about this, is this even possible or am I just wasting my time?

The code below is sending an e-mail to each e-mail address in my recordset, but it's sending one PER RECORD instead of PER E-MAIL ADDRESS...I can't find anything wrong - can you? If Not rst1.EOF Then Do While Not rst1.EOF emailto = rst1("[email]") strbody1 = strbody1 &...

Problem solved using: wwe-caption...

JMG, I tried what you suggest: wwe-caption: IIf(InStr([M].[wwe-caption],"<b>Order")<>0,Left([M].[wwe-caption],Len(Left([M].[wwe-caption],InStr([M].[wwe-caption],"<b>Order")))-1),IIf(InStr([M].[wwe-caption],"<font color=")<>0,Left([M].[wwe-caption],InStr([M].[wwe-caption],"<font...

I'm using a bunch of different functions to strip out certain data in my field "wwe-caption". The expression I'm using is: IIf(InStr([M].[wwe-caption],"<b>Order")<>0,Left([M].[wwe-caption],Len(Left([M].[wwe-caption],InStr([M].[wwe-caption],"<b>Order")))-1),IIf(InStr([M].[wwe-caption],"<font...

Thanks, but the problem is that each e-mail that goes out, should contain ALL the records associated with that e-mail address, not just the first one...any ideas on how to do that?

We'll I've looked everywhere and I cannot find out how to create a recordsetclone (of rst1)...I tried to do this without a recordsetclone, but the recordset is going one record too far (my e-mails are incorrect and are including one extra record) using the code below: If Not rst1.EOF Then Do...

I'm trying to write an if statement that compares the next record in my recordset to the current record and if the email field is different, do blah, if it's the same, end the if statement. So, in pseduocode, it looks like this: if rst1.current("[email]") <> rst1.next("[email]") then blah else...

I'm not quite sure where to start with this one...I have a query that returns data similar to what you see below: id--------desc-------- fax-----------------phone-------------email---------------code 123 stove 444-444-4444 444-444-4444 blah@aol.com abc 456 phone 333-333-3333 444-444-4444...

Good call - changed it to four and it works - thanks!

I have a form with the text boxes you see below and for some reason, when the code below executes, it is not formatting the date like I have specified (4 digits in the date). It's only using 2 digits. Any ideas on why this isn't working? strSQL = "insert into exported_data ( [first name], [last...

First, let me say that my linked tables are opening fine, but I have a query that uses one of my linked tables (it's linking to a foxpro database) and when I try to run the query, I get this error: ODBC connection failed - [Microsoft][ODBC Visual Fox Pro Driver] Operator/Operand type mismatch...

<Smacks myself in the face>. Thank you very much :p .