View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arun Arun is offline
external usenet poster
 
Posts: 103
Default Create Word Document from Excel

I've Invoice Data in Excel and I would like to create a word document when I
press Create Invoice button of shortcut key.

I'm able to create a word application and open a new document and start
filling in the data. However, I want to use a Word Template and fill in the
data at specific location. like Invoice No. in the Table Cell at Top Right
Corner and Invoice Date 1 Cell below, etc.

What is the best approach, I definitely do not want to use mail merge. I
currently use mail merge.

Thanks in Advance