inserting into a form
Posted on 2014-01-24
I have written vba to go through a table and concatenate all the email addresses into a string separated by semi-colons. The idea is to be able to just copy and paste the list into a "TO" field on someones email account for emailing everyone on the list. The end result looks like:
email1; email2; email3;..........
I want to take that string and insert it into a form named Email_addresses with a text box name email. At that point it would be just opening that form and doing the copy and paste.
There's my problem. I don't know how to get the variable list of the emails into the form field. All the information I can find is on inserting into a table not a form I need some help(or maybe a lot).