Copy items in a column to the clipboard

[kevinscomp]

I am in need of some help. I am looking to create a button in access that will allow a field to be copied the the clipboard based on information in a query and then separated by a ";" and then can be pasted in another program.



just some background to my database.
I have created a database to keep track of membership. In the Member Personal Info Table I have collected their email address's and then created a query "Active Member Personal Info" for Active Members to have their name and Email displayed in the query. Now I am trying to take the 140 members email address and paste it in a gmail BCC line by clicking paste rather than doing each individual record and then copying and pasting.

anyone have ideas or can help would be greatly appreciated. I havent worked with Macro's in years and not sure where to start on this but i am thinking i need to build and expression.

[June7]

Requires VBA code that opens recordset, loops through records, builds the address string.

Review: https://www.accessforums.net/program...ook-21903.html

Populate a textbox with the constructed string, have a button to copy textbox contents to clipboard:
Private Sub cmdCopy_Click()
Me!txtAddresses.SetFocus
DoCmd.RunCommand acCmdCopy
End Sub