Super! ! I don't know if there's any formatting export tricks, but you can also try the export to .xls or .rtf format and see if you like them better, I think they come out in tables, which you can quickly convert table to text in Word, but hopefully someone who is an expert on that end can provide more help! hth, Cathy Cherie <msogroup@xxxxxxxxx To: mso@xxxxxxxxxxxxx om> Sent by: cc: mso-bounce@freelist s.org Subject: [mso] Re: create text file from column contents 08/19/2004 04:27 PM Please respond to ..... mso Yippee..I'm there.. I made it...the only problem is that the TXT file is coming out like this: ----------------------------------------------------------------- | E-mail | ----------------------------------------------------------------- | xxxxx@xxxxxxx | ----------------------------------------------------------------- | xxxxx@xxxxxxx | ----------------------------------------------------------------- | xxxxx@xxxxxxx | ----------------------------------------------------------------- | xxxxx@xxxxxxxxxxxxxxx | ----------------------------------------------------------------- | xxx@xxxxxxx | and so forth (almost 500 addresses) how do I make it come out like this: xxxxx@xxxxxxx xxxxx@xxxxxxx xxxxx@xxxxxxx xxxxx@xxxxxxxxxxxxxxx xxx@xxxxxxx Thanks Cherie It was 8/19/2004 when Cathy.Evans@xxxxxxxxx mentioned: ----------------------Begin Quote------------------------ > >I apologize, I should have been more specific. I may have confused things, >however, when you were talking macro, were you talking macro from Word or >Access? I was giving Access macro directions, where you would create a new >macro, choose OutputTo or SendObject from the pull down box in the action >window, and fill in appropriate action arguments that appear below for each >command. > >What exact processes/softwares are you using for the mail merge or getting >the email addresses? Thank you, and sorry for the confusion. Cathy > ----------------------------------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ------------------------------------------------------------------------------------------------------- ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************