A merge exports data out of Cloud AMS that can be used for letters, mailings, labels, name badges, broadcast emails, faxes, and other forms of mass communication. When a merge is generated in Cloud AMS, the program creates a merge file in the folder indicated on the File Creation Complete dialog box. In the Cloud AMS File folder, locate the User folder, then open your folder within it.
You will find five separate types of files. The files start with an underscore (_) and contain your merge data.
Copy the _Combind.doc file onto your deskstop as this file contains everything from the other files.
When you open the file on Microsoft Excel, make sure that you have All Files selected so you can see the files you copied on your desktop.
You will have to format the data as the file is generated pipe-delimited format.