removing old items from a document...

D

Dooma

Ok. this is the case:

I have a document that contains 10k names. I copied 300 random names. Placed
them in a separate file and send them an e-mail. Now, I want to send an
e-mail to the 9700 names. But, the 300 names are impeded in the original
file. How can I remove the 300 names from the original 10k name document?
Please advice.
 
R

rajan deshpande

use macro
first copy 1 name , paste in another sheet, select your list clear contents of the name copied , choose another name , run macro in do - loop.
then select the column (Range Cells) of mailing list and use a macro to delete blank rows in the selection. no need of formula.

rajan



Dooma wrote:

What kind of question is that?
21-Oct-09

What kind of question is that?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
..NET Compact Framework File Deployment Tool
http://www.eggheadcafe.com/tutorial...be-97e9fcce7f10/net-compact-framework-fi.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
printing labels from an excel file 1
reference document records to one another in the same table 3
Deleting/Cleaning Document Properties 4
Comparing two columns 1
Another question, please! Thanks a bunch! 7
I want to insert a list of file names into a document 3
Text Manipulation from PDF 4

Top