VBA/Macro - Can this be done

[rankinc]

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

[Carim]

Hi Chris,

Yes, it is feasible and relatively simple ...

My recommendation is, outside of your project, to perform a couple of tiny tests with the mailmerge function ...

Look in F1 both in Excel and in Word for further explanation

HTH
Carim

[rankinc]

Thanks for the reply.

I have no problem using mail merge with excel and word, and have done on numerous occasions. Its the macro side of excel which I have no idea about. If I was performing this task I would just filter column L to show all fields containing a * and then complete the merge.

The people who are peforming the task are not really computer literate and would not be able to filter and perform the merge, so thats why I would like to try and write a macro that can automatically carry this task out for them; unfortunately I haven't got a clue on how, or were, to start when it comes to VBA and Macros.

Regards

Chris

[Carim]

Chris,

Well, with waht you are saying, the best solution fora quick start, is
1. to turn on the macro recorder
2. carefully go through all the steps
3. then, will come the time to adjust the VBA code

HTH
Carim

[rankinc]

How does the Macro recorder determine which cells have * in. There is over 1000 rows of information, maybe 15% have * in column L. Would I have to go into each row with the macro recorder.

[Carim]

Well...

something along this line ...

Please Login or Register  to view this content.

But do not worry ... the macro recorder will catch all your selections ...

HTH
Carim