concatenation on access

[paraphi]

I am pulling my hair out trying to get around
this "problem".

I am trying to
(a) concatenate or merge a list of rows in Tbl_A (email
addresses) into another Table (Tbl_B) that has a single
row which is the sum of all the email addresses seperated
by a semi-colon...
(b) open Outlook with the contents of Tbl_B in the "To..."

This is operated by a button on a Form which undertakes
the operation and sends the output to Outlook.

So...

Tbl_A (each email is seperate row)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Click on button in the form to concatenate / merge the
three emails to a single field in Tbl_B
(e-mail address removed) ; (e-mail address removed) ; (e-mail address removed)

The start outlook and place the contents of Tbl_B in the
To... for emailing.

Any advice.

Cheers

 

[Rick B]

First, don't store the result in a table. Simply create the string in your
form, query, or report. Anything that can be created on the fly should not
be stored. That is redundant. Also, what if you change an address in table
A, or delete one, or add one? Then tableB is wrong and outdated.

You are not clear if you are grabbing all the addresses from TableA, or just
ones that match a criteria (such as all the addresses for a particular
company). Regardless, you would most likely wnat to build code ties to your
form or report. The code should loop through the recordset and add on the
address. Not sure how you will need to build the loop based on your email,
but the code inside the loop would be something like...


varEmailList = varEmailList & "; " & NextEmail


Rick B


I am pulling my hair out trying to get around
this "problem".

I am trying to
(a) concatenate or merge a list of rows in Tbl_A (email
addresses) into another Table (Tbl_B) that has a single
row which is the sum of all the email addresses seperated
by a semi-colon...
(b) open Outlook with the contents of Tbl_B in the "To..."

This is operated by a button on a Form which undertakes
the operation and sends the output to Outlook.

So...

Tbl_A (each email is seperate row)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Click on button in the form to concatenate / merge the
three emails to a single field in Tbl_B
(e-mail address removed) ; (e-mail address removed) ; (e-mail address removed)

The start outlook and place the contents of Tbl_B in the
To... for emailing.

Any advice.

Cheers

 

[Duane Hookom]

There is a generic Concatenate() function with a demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.