Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

(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.

share|improve this question
    
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 Aug 24 '11 at 1:22

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer
    
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 Aug 24 '11 at 16:35
    
Will this work as a mail merge? If it doesn't, I can figure out how to make it work. –  daviesgeek Aug 24 '11 at 16:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.