How to use Mail Merge to Print Labels from ProviderSuite using Excel and Word

How to use Mail Merge to Print Labels from ProviderSuite using Excel and Word

How to use Mail Merge to Print Labels from ProviderSuite using Excel and Word 2010

  1. From Reports run Report “Patient List By Address Detail”
  2. Click Open in Excel
  3. Remove Report Name Header
  4. Remove Columns - A/C#, SSN, Work Phone, Home Phone and Email
  5. Select Entire worksheet
  6. Click highlighted buttons Wrap Text and Merge & Center to remove
  7. Remove the row between the header and the first patient’s name
  8. Next we need to split the patient name into two columns
  9. Insert four columns to the right of patient name
  10. Highlight Patient Name column
  11. Click Data tab
  12. Text to Columns
  13. Choose Delimited-Next
  14. Delimiter Check Space
  15. Column data format-General
  16. Finish
  17. Rename Columns Patient to First Name and add header of Last Name to the new last name column
  18. Remove Extra columns between Last Name and Address 1
  19. Rename worksheet to Mail, save document as Mail 1
  20. Open Microsoft Word
  21. Select Mailings tab
  22. Click Start Mail Merge select down triangle
  23. Select Step by Step mail merge wizard
  24. Select document type as labels
  25. Select Use the current document
  26. Select Label Options
  27. Choose the label type (e.g. 30 per page height 1”)
  28. Click Next
  29. Use an existing list should be selected
  30. Click Browse
  31. Find Mail 1 excel document
  32. Select Mail 1 Document
  33. Select Mail 1 Document as the data source
  34. Click Next
  35. Select Address block
  36. Can use arrows to preview your labels, click ok
  37. Select Update all labels
  38. Next preview labels
  39. Next complete the merge
  40. Print *You might have to bring them forward to view a certain amount

    • Related Articles

    • ProviderSuite 7.2 Release Notes

      ProviderSuite 7.2 Release Notes are attached to this article. Manage Patient Payments Easier The Patient Payments functionality of the Billing Manager applet (Billing Manager> Accounting> Patient Payments) has been added to the Web App. This new ...
    • Patient Address Report for Mailing Labels

      To generate a list of patient addresses for appointment reminder postcards or other mailings, please use the following steps. Go to ProviderSuite > Reports > Scheduling Reports Go to the Appointment List by Patient report Set the report parameters ...
    • How to Print EOBs / ERAs from Billing Applet

      Please use the following steps to print EOBs / ERAs from the Billing Applet:   Login to ProviderSuite Select the “Claims” tab Select “Launch Billing” to load Billing Applet Click on “ Accounting” Click on “Payment Application” Click on “Batch” then ...
    • Unable to Print an EOB from the EDI Portal

      Unable to Print an EOB from the EDI Portal You can resolve this issue using one of the follow resolutions: 1. Begin Using Google Chrome as your default Web Browser. While we have optimized ProviderSuite for use with the Microsoft browsers, you can ...
    • How to update Core Account Address Information

      Note: You must be an "Account Manager" user in ProviderSuite to perform this task. If you do not have access to the Settings tab in the ProviderSuite, please forward these instructions to another user with Account Manager permissions.  Log into ...