#1
|
|||
|
|||
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 |
|
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 |