Macros / Scripts in Word and Excel

[dleo]

Every month I send out an e-newsletter to the people in my database. To get
the addresses I simply export their information into an Excel file,
copy/paste into Word, then copy/paste them into the e-mail.

In the exporting process however, multiple e-mails may be put into the same
Excel cell (ex. "(e-mail address removed),[email protected]"). That means every
month I have to visually look down a long list to make sure each e-mail is on
its own line.

Is there some sort of macro or script I could create to eliminate this step?
Something along the lines of "If there is a "," move the rest of the cell
contents into a new cell below".

I am new to macros/scripts, so any help would be appreciated.

Thanks!

 

[Douglas J. Steele]

Sorry, but this newsgroup is for questions about queries in Access, the
database product that's part of Office Professional.

I think you'd be best off reposting your question to a newsgroup related to
Excel (although what you're trying to do could easily be accomplished in
Access! <g>)