Hi,

I hope someone would be able to help me with the following problem.

I want to try a perform a mail merge (with MS Word) on a monthly basis for invoicing customers. Columns A-I will contain customer information and Column L will be populated by a *, this informs us that an invoice is required. Is it possible to write a macro wereby when a User button is pressed Excel will pull over information in Columns A-L, only were a * is present in Column L, and insert it into a new Word Document. The information that is transferred cannot be deleted and must stay in the s/sheet.

This kind of thing is completely new to me so any help would be very appreciated.

TIA

Chris