My Assistant
Site Message
(Message will auto close in 2 seconds)
 Convert List Of E-Mail Addresses to a Single Line Seperated by ";"
|
|
 May 5 2010, 01:30 PM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 80 From: Tennessee  |
I have a query that captures the e-mail address field of a table and lists them as individual records.
I need to be able to grab each of these records and put them into a 'copy-from' field so they can be pasted into the "To" line of Outlook in this format: abc@gmail.com; red@aol.com: blue @nobody.com I am currently having to copy/paste these into Excel and do it but this is pretty clunky. Any help would be appriciated. |
 |
 
|
Posts in this topic
JimBritt Convert List Of E-Mail Addresses to a Single Line Seperated by ";" May 5 2010, 01:30 PM
GroverParkGeorge You'll need to do this in a VBA function.
The... May 5 2010, 08:54 PM JimBritt I did the search and read seveal of the posts but ... May 6 2010, 08:14 AM
GroverParkGeorge Here is a discussion that speaks to your exact req... May 6 2010, 08:59 AM |
  |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th June 2013 - 07:41 PM |