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

If you are doing one client at a time, or have a set list of client numbers
in a range somewhere, I'd suggest you just create (or re-create) your fax
template in Excel. I did this for a previous employer, and had excel
generate several dozen faxes to our different sites each day (using a modem
card). We never printed out the actual hardcopy fax on the sending end, we
just used Excel to auto-fax the sheet to the correct number, then updated
the sheet with the next site's data, and faxed it, and so on.... I suspect
it is a much easier solution than dropping everything over to Word.
:)
Keith

"Frans Verhaar" wrote in message
...
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

I'm also working on finding a way to send a fax directly from within
Excel. I can open the word document, alter what I need to alter, but
then I'm a bit stumped on how to actually send the fax instead of just
printing it.

Suggestions?

KR wrote:
If you are doing one client at a time, or have a set list of client numbers
in a range somewhere, I'd suggest you just create (or re-create) your fax
template in Excel. I did this for a previous employer, and had excel
generate several dozen faxes to our different sites each day (using a modem
card). We never printed out the actual hardcopy fax on the sending end, we
just used Excel to auto-fax the sheet to the correct number, then updated
the sheet with the next site's data, and faxed it, and so on.... I suspect
it is a much easier solution than dropping everything over to Word.
:)
Keith

"Frans Verhaar" wrote in message
...
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