0

(Note: I'm am not sure if this question fits in this StackExchange site, so please correct me if it doesn't belong)

To cut my problem short: I'm trying to make a Word document which prints data from a Excel document. Is it possible to link an Excel and Word document? Almost like this:

Data A(A,1)
Data B(A,2)
etc.

I have tried using templates and just simply printing the excel document without the lines, but my "requirements" are too specific and complex.

1
  • On Windows, this is achievable with DDE. I don't know if it's possible on OS X. Though, apparently VBE is working on Office 2011, so possibly programmatically?
    – user479
    Commented Aug 24, 2011 at 1:22

1 Answer 1

0

Yes, it is. I don't know exactly what you are doing, but doing a mail merge should link a Word document to an Excel spreadsheet. Let me know what you are using it for, and I can post further instructions.

2
  • I am trying to create a school phone directory where each student's entry will print as if in a small box (as opposed to in a straight line across the page). Each entry will include five lines of info taken from Excel. The directory will be printed in a small booklet format (half an 8.5 x 11) with approx 12 entries/page (If you even need all that information).
    – Andy B
    Commented Aug 24, 2011 at 16:35
  • Will this work as a mail merge? If it doesn't, I can figure out how to make it work.
    – daviesgeek
    Commented Aug 24, 2011 at 16:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .