I have a database (Cnpr 2003.mdb) and inside a table "Table1" and a field in that table "Email_Addr". I have a list of names and email addresses. i am trying to create a field that merges all of the records "email addresses" into 1 string separated by a ";". (so i can email via outlook to a list of people from my database). I have played with the code, but have been unsucessful. it has been 4 years since i have done any of this and it has completely escaped me!!! Any help?
creating a field "String" from multiple records
- Thread starter pam0566
- Start date
Brianwarnock
Retired
- Local time
- Today, 10:34
- Joined
- Jun 2, 2003
- Messages
- 12,667
You have posted this in three forums it is very annoying and does not encourage others to help you
Brian
Brian
Brianwarnock
Retired
- Local time
- Today, 10:34
- Joined
- Jun 2, 2003
- Messages
- 12,667
I think that you have deleted the thread I answered the question in 
To concatenated strings use &
String1 & ";" & string2
Brian
To concatenated strings use &
String1 & ";" & string2
Brian
