Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Generating Customer Li...
Microsoft Dynamics RMS (Archived)

Generating Customer List from RMS that INCLUDES the e-mail

(0) ShareShare
ReportReport
Posted on by Family Fun Hobbies 195
Whenever I use the Customer List Report in Store Ops Manager, it gives me every piece of information I want EXCEPT for the customers' email addresses. We will probably not do much by snail mail (cost, and not as green), and want to know how to generate a customer list that includes their Name, Street Address, City, State, Zip Code, Phone, and E-Mail. Help! Thanks in advance,

*This post is locked for comments

  • Sam Merfi Profile Picture
    Sam Merfi 45 on at
    Generating Customer List from RMS that INCLUDES the e-mail

    ScottM:

    You can just place (copy & paste) the text of your SQL code inside your reply in lieu of an attachment that cannot be opened in this new RMS Community.

    Sam Merfi

  • Family Fun Hobbies Profile Picture
    Family Fun Hobbies 195 on at
    Re: Re: Re: Re: Re: Re: Generating Customer List from RMS that INCLUDES the e-mail
    Any replies or attachments can be sent to me at: sales at familyfunhobbies dot com Thanks for everyone's help! Rob Placer - Owner
  • Craig Wood Profile Picture
    Craig Wood 785 on at
    Re: Re: Re: Re: Re: Re: Generating Customer List from RMS that INCLUDES the e-mail
    Attachments were a major reason for the success of the RMS NG. Microsoft needs to add that ability as fast as possible. Not having the ability of users such as Scott to upload attachments will severely limit the quality of support received here. I can't tell you how many times I have benefited from the generosity of contributers willing to use their time and talents to figure out a custom SQL Script, report, receipt, html, etc. and make it available for everyone at no charge. MS shouldn't make it hard for them to help. New users are the ones really losing out here. I decided shortly after I started frequenting the NG that I was going to download and save every single attachment posted, even ones that had no meaning to me at the time. Now I am really happy I did that because I have amassed quite a collection. I shared those resources frequently, but now I can't. Does anyone have a workaround to this? Maybe a site somewhere that offers the ability to upload attachments and doesn't cost anything. MS needs to fix this quick. Craig
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Generating Customer List from RMS that INCLUDES the e-mail

    Guess what a major feature missing from the forum. Did you guess yet?

    Attachments

    It was a frequently used function in the old newsgroup so users, like yourself, could generously share their custom reports, invoice and receipt templates, etc. 

     Marc

     

  • ScottM Profile Picture
    ScottM 540 on at
    Re: Re: Re: Re: Generating Customer List from RMS that INCLUDES the e-mail

    I made a custom report that shows what you need.

    You will need to put this file into the Reports folder in Store Operations

    The path will be something like Program Files\Microsoft Retail Management System\Store Operations\Reports

    Then in Manager, go to Reports\Custom and it will be there.  You will have to go to show/hide columns and check the email column.

     

    If someone can tell me how to attach this, it's ready to go, do I have to get permission to attach?

  • Family Fun Hobbies Profile Picture
    Family Fun Hobbies 195 on at
    Re: Re: Re: Generating Customer List from RMS that INCLUDES the e-mail
    When I go into Store Operations Manager, then to Reports > Customer > List I predominantly see a whole bunch of "Custom Number" or "Custom Text" selections. Nothing for the options you listed above. If your solution requires me to know SQL, then we are out of luck. I would have thought that the ability to simply extract E-Mail addresses would have been a fairly standard option and report. The more I use RMS, the more thoroughly disillusioned I am becoming that perhaps I got in over my head, and spent more money on something that, while it definitely CAN produce a lot of reports and benefits, is not doing so for me. It seems the only way to get those benefits is to SPEND MORE MONEY to get someone to customize the software... and of course, if we wanted a custom POS, we would have bought it from the beginning.
  • ScottM Profile Picture
    ScottM 540 on at
    Re: Re: Generating Customer List from RMS that INCLUDES the e-mail

     I know this post is a little old, but you can just run this SQL query and it will give you this information.

    select firstname, lastname, City, State, Address, Address2, Zip, PhoneNumber, EmailAddress from customer

     

    Hope this helps!

  • CARLYSS Profile Picture
    CARLYSS 25 on at
    Re: Generating Customer List from RMS that INCLUDES the e-mail

    Where you able to solve this problem. I am running into the same issue as yourself.....Let me know.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans