LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill out Word template form from Excel spreadsheet YiChing Excel Discussion (Misc queries) 1 March 31st 09 10:53 PM
How can I link between a Word template and an Excel template Josh Excel Discussion (Misc queries) 0 April 1st 08 12:36 AM
Create Fill In Template in Excel? Gretchen Excel Discussion (Misc queries) 1 March 18th 08 08:59 PM
create a fill in template to tab to fill in cells Excel-erator Excel Discussion (Misc queries) 2 July 6th 05 09:57 PM
How do I fill an Excel template from a file Alejandro J. Formichelli Excel Worksheet Functions 0 March 21st 05 02:59 PM


All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"