Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel e-mail list to netscape
First - I'm not a VBA programmer, so I have to keep this simple! I have a list of filtered Excel e-mail addresses. Is there a way to copy these and have them appear in Netscape? Right now, I have to filter my data list, copy the filtered e-mail addresses, paste them into MS Word, Convert the resultant table, search and replace the paragraph marks with commas, then delete the two extra commas at then end. Once this is done, I can copy and paste directly into the Netscape address window. Obviously, alot of steps. I'd like my users to just be able to highlight the filtered e-mail list in Excel, press an assigned Macro button, and have Netscape open with the e-mail addresses appearing in the address window. Ideas??? Thanks! -- Richinmemphis ------------------------------------------------------------------------ Richinmemphis's Profile: http://www.excelforum.com/member.php...o&userid=35378 View this thread: http://www.excelforum.com/showthread...hreadid=551627 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel e-mail list to netscape
Copy the visible cells to a new (temporary) worksheet in column A.
Then in B1, put this formula: =a1 In B2, put this formula: =b1&","&a2 And drag down the column. Copy that last cell and paste into your email program. Richinmemphis wrote: First - I'm not a VBA programmer, so I have to keep this simple! I have a list of filtered Excel e-mail addresses. Is there a way to copy these and have them appear in Netscape? Right now, I have to filter my data list, copy the filtered e-mail addresses, paste them into MS Word, Convert the resultant table, search and replace the paragraph marks with commas, then delete the two extra commas at then end. Once this is done, I can copy and paste directly into the Netscape address window. Obviously, alot of steps. I'd like my users to just be able to highlight the filtered e-mail list in Excel, press an assigned Macro button, and have Netscape open with the e-mail addresses appearing in the address window. Ideas??? Thanks! -- Richinmemphis ------------------------------------------------------------------------ Richinmemphis's Profile: http://www.excelforum.com/member.php...o&userid=35378 View this thread: http://www.excelforum.com/showthread...hreadid=551627 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel e-mail list to netscape
Hi Rich,
From what you describe, you can simply have Excel create a CSV (comma separated variables) file. File, Save As If you have other characters interferring, you can use Replace (Ctrl+H) to remove them. If you want you could modify the TrimALL macro to remove unwanted characters. The description in this area would also help you identify what characters i.e. =CODE(MID(A1,14,1)) to find what the 14th character actully is. http://www.mvps.org/dmcritchie/excel/join.htm#trimall If you have unwanted commas at the end, then remove columns at the right end of your worksheet. Use Ctrl+End to see where Excel thinks the data ends. If you need another comma at the end then enter a single quote in a cell to indicate an empty text string. You should be able to all of this without macros, but if you want to remove extraneous spaces and remove other character (replace with a space) the macro would help, and link to how to install and use a macro can be found at the top of the join.htm page (above), or see http://www.mvps.org/dmcritchie/excel....htm#havemacro --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Richinmemphis" wrote in message news:Richinmemphis.29cvow_1150227635.2339@excelfor um-nospam.com... First - I'm not a VBA programmer, so I have to keep this simple! I have a list of filtered Excel e-mail addresses. Is there a way to copy these and have them appear in Netscape? Right now, I have to filter my data list, copy the filtered e-mail addresses, paste them into MS Word, Convert the resultant table, search and replace the paragraph marks with commas, then delete the two extra commas at then end. Once this is done, I can copy and paste directly into the Netscape address window. Obviously, alot of steps. I'd like my users to just be able to highlight the filtered e-mail list in Excel, press an assigned Macro button, and have Netscape open with the e-mail addresses appearing in the address window. Ideas??? Thanks! -- Richinmemphis ------------------------------------------------------------------------ Richinmemphis's Profile: http://www.excelforum.com/member.php...o&userid=35378 View this thread: http://www.excelforum.com/showthread...hreadid=551627 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Is it possible to create a mailing list in excel, not importing d. | New Users to Excel | |||
.txt file to mail list (excel best option) | New Users to Excel | |||
create price list from excel sheet | Excel Discussion (Misc queries) |