I FINALLY GOT IT! 1

[BLBurden]

After 2 week of pulling out my hair and spending sleepless nights on this one thing. It took a search back in October from that wonderderful (nathan1967) I will never stop saying his name, to find an answer to my question of how to get my list of emails in my comboBox to show up in my To: box in outlook by individuals.

I got that to happen, and that was the greates and biggest step for me. But when it goes over, it takes .....Smth, John and turns it to Smith;John which is trying to fihd names ending in Smith and Johns. Any suggesstion why it does this, and can it be fixed?

Also, while I am writing, I need to know how to Attach the form or record that is associated with that name in the email box, to go over to outlook also.

Thanks.

Always grateful

 

[PWise]

this is happaning beacus in the control panel regional settings number tab list separator is set to "," if you change it there it wont change a "," to ";" but i dont know where you do need it as a ","

 

[BLBurden]

pwise, you are very wise, it works perfectly. Thanks bunches

 

[PWise]

what did you change the list separator to
please let if you have any problems with the new list separator

 

[BLBurden]

To pwise: First I changed it to a dash(-), but I had a problem with one of my IFF function in my query, so I went back and changed it to a semicolon( and it works perfect, it takes my emails over with a comma seperator from my DB, and it also remains a comma seperator when I send just regular emails within the company through Outlook.

Again thanks a whole heap for all you all help.

Forever grateful,
Brenda