Ali Edwards
Registered User.
- Local time
- Today, 15:55
- Joined
- Apr 19, 2001
- Messages
- 68
I have a query with a list of email addresses in it, one per record. Is there a way of getting these into a list, each one separated by a comma, so that I can copy and paste it into an email? The list could be a form with one large unbound field to temporarily place the email addresses in until I have copied and pasted into the email.
Up until now I had a very clunky method which worked around the sendkeys method.
It opened the query, copied the first record, opened a form (with just one large unbound field), pasted, reopened the query, copied the second record, reopened the form, pasted a comma followed by the second record etc etc. It used to work but for some reason it is now failing me (since changing to Windows 2000). In any case I always new there should be a better way but I still can't find one!
Any help appreciated.
Thanks
Ali
Up until now I had a very clunky method which worked around the sendkeys method.
It opened the query, copied the first record, opened a form (with just one large unbound field), pasted, reopened the query, copied the second record, reopened the form, pasted a comma followed by the second record etc etc. It used to work but for some reason it is now failing me (since changing to Windows 2000). In any case I always new there should be a better way but I still can't find one!
Any help appreciated.
Thanks
Ali