PDA

View Full Version : Help with excel and word. Sounds easy, but its not.



Aggie
06-14-2016, 06:53 PM
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..

mdmackillop
06-15-2016, 12:25 AM
Welcome to VBAX
Can you post sample Word and Excel showing your proposed layout. Used Go Advanced/Manage attachments.

Aggie
06-15-2016, 09:08 AM
Welcome to VBAX
Can you post sample Word and Excel showing your proposed layout. Used Go Advanced/Manage attachments.

I want the addresss to go with address and name to go to name but a separate 5x7 per line.

mdmackillop
06-15-2016, 09:59 AM
Create a mail merge Word Document.

Aggie
06-15-2016, 10:05 AM
what does that mean?

mdmackillop
06-15-2016, 10:25 AM
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 (https://support.office.com/en-us/article/Use-mail-merge-to-create-and-send-bulk-mail-labels-and-envelopes-f488ed5b-b849-4c11-9cff-932c49474705?ui=en-US&rs=en-US&ad=US)