Mail merge from excel

bluenosebex · #1 07-28-2015, 03:11 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge to create specific number of table rows	flackend	Mail Merge	4	12-01-2023 02:49 PM
Using Mail Merge to create summary report in ONE document	ChandaS	Mail Merge	1	12-19-2014 10:16 PM
Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes	esherwood	Mail Merge	1	07-21-2014 09:55 PM
How to use mail merge to create a list sorted by category in Word	elisa2013	Mail Merge	5	03-14-2014 02:35 AM
Urgent Supprt Need to Create Mail Merge letter	risnasmhd	Mail Merge	1	09-29-2013 08:11 PM