WORD: Merge code changing during merging process

Shiremaid

Board Regular
Joined
Jun 18, 2013
Messages
73
We have a template that we use for merging and have come upon a weird glitch.

We have a merge code for the Contact's Name and a merge code for their Company.

We can see in the template that in one paragraph we do have the correct merge code for the name, but when we connect to the excel spreadsheet to actually merge the information in, we can see the merge code change to the one for the Company.

Does anyone know how on earth merging (with the wizard, exactly as we always do) would replace one merge code with another?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
That suggests either that the mailmerge main document has been set up incorrectly, or that field names in the data source have been changed. Alternatively, the mailmerge main document might have an IF field that's being used to choose between the Contact's Name and their Company according to some (unspecified) condtion. The merge process won't swap fields around. If you open the mailmerge main document and toggle the field code display 'on' (e.g. via Alt-F9), you should be able to see what field constructions are in use.
 
Upvote 0

Forum statistics

Threads
1,223,796
Messages
6,174,658
Members
452,575
Latest member
Fstick546

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top