View Single Post
 
Old 07-28-2015, 03:11 PM
bluenosebex bluenosebex is offline Windows 8 Office 2013
Novice
 
Join Date: Jul 2015
Posts: 3
bluenosebex is on a distinguished road
Default Mail merge from excel - need to create sheets and create a table

Hi all first post from a no techie so please be gentle... Attached excel sheet and word document.

The excel sheet is in two halves, the green columns form the table at the top of the word doc. I want to pull into the word doc table any record that doesn't say NAD..

The second half of the excel sheet columns in purple is the rest of the info for the work sheets that follow on the word doc. Each record needs a sheet completed as per page 2 of the MM.

I can get the mail merge to create the sample sheets one for each record, but I cant get the table on page one completed. I need this table to have all the records except those that say NAD.

Can anyone help? Sorry if I'm being confusing or if there is a far more obvious/easy way of doing this!

Thanks
Attached Files
File Type: xlsx MM data.xlsx (10.4 KB, 19 views)
File Type: docx MM template.docx (21.2 KB, 19 views)
Reply With Quote