Help with excel and word. Sounds easy, but its not.
I am trying to make a 5x7 sheet with three areas for data in a sentence, word needs to pull the data from excel and do this for each line and word needs to make a new 5x7 sheet for every new line. so if i have 10 lines with 3 data points in excel i should have 10 pages in word. I just dont know how to do this.. Please help..
Welcome to VBAX
Can you post sample Word and Excel showing your proposed layout. Used Go Advanced/Manage attachments.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I want the addresss to go with address and name to go to name but a separate 5x7 per line.Originally Posted by mdmackillop
Create a mail merge Word Document.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
what does that mean?
Go to Word and look for the Mailings tab. There are tools there to create a document which pulls data from the table, designed exactly for this purpose.
I would not do this any other way.
There is an article here
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote