Search results

Thanks to all. I now DO have a plain text file with all of the email addresses I need to get out of my table as a list. What's the easiest way to do that? Anyone point me in the right direction? Thanks in advance.

Well, I do have (if I can find it) an email harvetsing program by MaxProg (don't use it anymore for email campaigns as that is illegal here in Aus) but for a maintenace job like this, it might be okay. It simply strips email addresses from whatever you drop onto it and creates a list of them...

Hi guys Seeking some direction re some data I need to delete. Short stoy is that I did an email merge to a list to clean it out ... as a result I have about 1200 emails that have 'bounced'. I want to delete these email addresses from the database as they are useless to me. Is there some way of...

Thankis Bob. its: SELECT IIf(IsNull([Surname]),IIf(IsNull([First Name(s)]),[Company or Group],[First Name(s)]),IIf(IsNull([First Name(s)]),[Surname],[Surname] & ", " & [First Name(s)])) AS [File As], IIf(IsNull([Surname]),IIf(IsNull([First Name(s)]),[Company or Group],[First...

Since posting I tried running the 'Customer Extended" query mentioned below and it DOES find all the records so my initial work arounds may be misconceived. I suppose it must be an oject that is evoked after bthat query is run that is causing my proble. In case it helps, here's the 'Row Source'...

Ahh, the penny's dropped now. Excellent stuff. Worked a treat!!! You're the man! Many thanks again. BTW, I used the same approach to generate a list of preferred addresses for my contacts (ie, home or work!) !!!!! Awesome. Peter

Thanks John, but I won't even begin to say that I understood any of that. Sorry but I'm not that up with programming etc, just a plodder. The reason I wanted to do this (or somethign smilar) was so that I could create one field for email mail merges. I fear rthat doing anything other than...

Thanks John: Is Not Null And Not "" fixed the problem. Cheers Peter

How can it be that a query returns a record when the "Is Not Null" criteria is used that is completely empty? This doesn't happed all the time but sometimes when I run a query a few records are picked up where the field I've queried has nothing in it at all ... Has anyone else experienced this...

Hi techiies Could anyone asssit with advise on this? I want to create and update query that will 'find' cells in one field that are not null and then copy that data into another cell in the same record that IS null. Real world: My database has Work Email adresses [Work Email Address] and...

At last, John. I got it to work! Thank you so much and thanks too to Bob for recompiling which must have assisted as well. Phew! That's one thiong off my mind., Kudos to you both. Peter R

Thanks John, so is this the crietria I need? Left([Alternate Email Address 1],InStr([Alternate Email Address 1],"#")<>"0") or would it be: Left([Alternate Email Address 1],InStr([Alternate Email Address 1],"#")<>"0")-1) I ask as the first one deleted everything in the field :-( luckily I...

Bab Larson, you my friend are a bloody genius!!!! I did as you've described and John's code ran perfectly! Well done and thank you both. Now, just one other small thing before I run this on my 'real' database. If you look back thjrough the thread (hope you're following too John) I wanted to...

Aaargghghhh! Don't say that!!!! I repaired etc and it's no different. Couldn't it be that the function is missing? (Not that I know how to find out and/or replace it if it is). P

John It worked perfectly in a new database. What does that infer? Peter

Ooops, I meant John, not Bob! Sorry!!!!!@!

Thanks Bob. This is bizarre to say the least. I unzipped your test and ran the update and it worked fine. I copied the code into my upate query with the only change being to the name of the field I want to update. Here is the result: (see attached pic as I couldn't work out how to embed a...

Sorry it says "Undefined function 'Left' in expression"

Used: Left([Alternate Email Address 1],InStr([Alternate Email Address 1],"#")-1) Still returned the same error "Undefined left in expression" Maybe I'm terminal! Peter

Sorry John, I tried it as an update query on the tabel AND tghe main form I ised and it atill can up with the undefined Left error message ... this is the sytax I used in my update query where tyhe datase I';m using is called MMDATABASE, the main tabe inside it is CONTACTS and the main...