[Stillasfan]

I have a non-profit org that requires multiple forms of data and information collection. I am looking for shortcuts to make my life more sane. I have an excel document with a couple hundred lines of data, including client names, addresses, etc. I also have a Word document that requires the data that is contained in the Excel document to be filled into specific places. Can I have excel generate a new Word document form a template using the Excel data? I am using Microsft Office 2007. I would need a seperate document for each line. Thanks for any help anyone can provide.

[Bestm8ts]

Hey,
I have just the thing!

I am a Macro novice so please don't expect me to be able to explain how this works.

If you create a button and assign this macro to it, when clicking the button it will export everything between two cells into a word document (as an image).

The important bits you've got to worry about are:

Set wd = wdApp.Documents.Open("C:\test.doc") - c:\test.doc is the location of a word document (you have to set this up).

Range("A1:G22").CopyPicture xlScreen, xlPicture - The Range between cells is what is coppied.




Sub PasteToWord()

Dim wdApp As Object
Dim wd As Object

On Error Resume Next
Set wdApp = GetObject(, "Word.Application")
If Err.Number <> 0 Then
Set wdApp = CreateObject("Word.Application")
End If
On Error GoTo 0

Set wd = wdApp.Documents.Open("C:\test.doc")

wdApp.Visible = True

Range("A1:G22").CopyPicture xlScreen, xlPicture
wd.Range.Paste

End Sub



Hope this helps!

[Stillasfan]

Thanks for the info. I very unfamilar with the complex side of excel. How do I create a button? Also, I need the data in each cell to go to a specific place in the template. Will this do that?