View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frans Verhaar Frans Verhaar is offline
external usenet poster
 
Posts: 10
Default Fill FAX template in Word from Excel VBA

Hi,

My girlfriend works at a department on credit control. I made her a VBA code
that performs certain taks for her. After downloading all outstanding
invoices, the code analyses which invoices are more than 3 months old. Make
some further calculations etc. I wrote a nice code for that and it works
just fine.

I would like to add a button, that calls a macro which asks a clientnumber
to be entered and then opens MS Word and prepares a fax message to this
client including all his outstanding invoices and contact details. However,
I do not know how to fill a Word template from excel VBA. I do not first
want MS Word to be opened and do a mail merge.

Any suggestions?
Regards,
Frans