Fill FAX template in Word from Excel VBA

[Frans Verhaar]

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

 

[KR]

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

 

[Edmond3CD]

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?