creating a paragraph with a column ?

[Guest]

Hi all
I am using an access database to maintaining the data of a small group of
people. I am very comfortable with Access. Every now & then I send email to a
group of people, who I have query to find their email address (which is a
column in a table in my DB) which I & process in excel or word. Make this
column into a paragraph which can be cut & pasted to e-mail’s to address.

I have this question. I am thinking of creating a report which summarizes a
column of email address with separator (; or ‘) so that anybody can copy the
text & paste it to their outlook outgoing address. Instead of me going thru
the procedure of querying & processing in excel or word.
In a sentence is a way to summarize a column of data into a paragraph??

Thanks
Sara

 

[arthurjr07]

I suggest you create a new form then Place a text box on that form.

Then copy and paste this code to the form load event.

Dim rs As Recordset
Set rs = New ADODB.Recordset
rs.Open "SELECT EMailColumnName FROM EmployeeTableName",
CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly
rs.MoveFirst
email = ""
While Not rs.EOF
email = email & Trim(rs.Fields(0)) & ","
rs.MoveNext
Wend
email = Left(email, Len(email) - 1)
Me.Text0.SetFocus
Me.Text0.Text = email

Note: Be sure you replace
EMailColumnName and the EmployeeTableName