Re: Concatenate email addresses

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

See John's suggestion, also Duane has a very good sample on the link he
provided. The logic is almost the same but making it generic makes the
function more flexible, i.e. you can pass Table Name, Field Name, Separator...
etc.

Bonnie A wrote:
Hi NuBie! Thanks so much for the reply. Sorry I took so long to check it.

So I need to take your code and create a new MODULE? Then name it, compile
it and then create a button on a form to run it?

I need a quick paragraph on 'what to do with what you gave me'. It would
give me the trail to follow WITH the tool provided.

Thank you very much for your time and the wonderful reply. I just need to
be sure what to do with it. I know I need to be sure I use MY table name and
MY field name. I'm okay with that.

It doesn't look like an expression, it looks like module VB. I just don't
get in there much but being able to do this would so much help me with
notifying clients in bulk rather than copy and paste myself ill.

Thanks again!
You need to loop thru all records and get each email address and then
CONCATENATE :
[quoted text clipped - 55 lines]

Bonnie

--
spread the WORD

Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Calculate a percentage using 2 different query totals
    ... Duane, after thinking through the above information that I have just written ... you maybe the answer is to create 2 other tables with a unique ProductID as ... Do you think I'm on the right track or do you have another suggestion. ... One query contains only orders from a single customer while the other ...
    (microsoft.public.access.tablesdbdesign)
  • Re: OT: Jury Selection
    ... okay, I'll explain... ... This is the first time in the Zeppelin we've had a working toilet, ... and Ortelia sneered at my 3 x 5 box suggestion - she wanted a ... a cargo van from Home Depot to cart it home. ...
    (rec.outdoors.rv-travel)
  • Re: Week Numbers
    ... Apply my suggestion with your new requirements to get something like: ... You should be able to set the column headings property to the appropriate ... > Thanks for your reply Duane. ... >>>I have a crosstab query that is used as the source for a form. ...
    (microsoft.public.access.queries)
  • Re: Need another If/then code
    ... Thanks for your suggestion. ... have this form set up with these fields linked to a table. ... "Duane Hookom" wrote: ... I just found this forum TODAY! ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to: End an errant program?
    ... Okay, this is what the "Activity Viewer" already will perform. ... here we have a suggestion that for force quitting a hung task that opening ... doing an option-click on the dock and selecting the force quit option. ...
    (comp.sys.mac.misc)