Mail Merge Topics

Adidas

New Member
Joined
Feb 19, 2002
Messages
1
I'm using Excel 2000

For Mail Merge I can use it fine but when I insert mail merge topics only one topic appears..

Excel file
5 topics -- First name, Last, State, City, Address

I want these topics to appear in Word to a basic form letter I have created and all it will let me insert is First name, the other topics do not appear is there something I'm not doing. I defined the block in Excel as a name so it could find it but it seems not to be working the way I want it to... HELP!!!!!!!!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
I have only ever used Excel as mail merge data, with the field names in row 1 with data beneath
 
Upvote 0
Hi

Use word to merge excel data base its custom that way insert the fields and your awys set the source dat to your XLS file and done

Rdgs
==========
Jack
 
Upvote 0

Forum statistics

Threads
1,214,520
Messages
6,120,017
Members
448,936
Latest member
almerpogi

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