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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >