- Creating Text Fields In Word
- Can I Merge Multiple Text Fields In Word 2011 For Mac
- Insert Text Fields In Word Document
- Can I Merge Multiple Text Fields In Word 2011 For Mac Download
Mar 19, 2018 What you can do is create two separate hidden text fields for the two pieces of data, and set up another visible field that combines the two other field values in the way you want, using a custom Calculate script.
- You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data.
- Microsoft Office for Mac 2011 tutorial: Use Mail Merge to create a form letter 2 1. Understand the basics The Mail Merge Manager combines, or merges, information from a data source with information in a Word.
- How to Combine Text from Multiple Cells into One Cell in Excel Lori Kaufman November 8, 2016, 10:24am EDT If you have a large worksheet in an Excel workbook in which you need to combine text from multiple cells, you can breathe a sigh of relief because you don’t have to retype all that text.
Active5 years, 9 months ago
I am trying to do a Mail Merge where I have 200 Franchise Owners, with approximately 1200 staff members who have taken part in an incentive program. I need to send a letter to the Franchise Owners detailing each of their staff members and how much they have won.
I have used the following tutorials and copied their code with modifications where needand for the various fields.
However, no matter what I try, when I go to complete the merge a new document is created for each individual staff member, rather than having a staff list for each of the 200 franchises.
Creating Text Fields In Word
This is the full code I have for the letter
Any help would be great, as have been tearing my hair out trying to get this to work. Have tried copying the code verbatim from the two tutorials above and only changed the fields around to match mine but still no such luck
mr mojo risinmr mojo risin
1 Answer
The field names in your current code suggests that you may have a '3-level merge', i.e. where you want output like the following:
and so on.
But the structure of your current code suggests a 2-level merge, more like
If it's 2-level the suggestions below may nearly be enough. If it's 3-level, more will be needed.
Can I Merge Multiple Text Fields In Word 2011 For Mac
You have to think a bit 'back to front' to get this right. The second tutorial referenced in the video has a tutorial which helps, but you have to follow it closely.
It's critical your mail merge main document is actually set up as a Directory merge (Catalog merge on Mac Word), otherwise you will always get a page break between every Customer (or Staff) record.
As usual, it's also important that all the { } are actually the special field code braces that you can insert using ctrl-F9 on WIndows WOrd, not the ordinary ones you type on the keyboard
I think you need to start with field coding more like this (compare it with the tutorial if you like, as the tutorial may do it in a more simple way):
Where I have put --PB--, you need to insert a page break instead.
Insert Text Fields In Word Document
user181946