1) Create a view of the records you want the GUIDs for
2) Export as a Dynamic list
3) Right click on A2 and select 'Edit Query...'
4) A bunch of boxes will pop up. Close them as soon as they open
5) You will now see in your workbook an extra column has magically appeared on the end. These are your GUIDs
In v4 things have been made much simpler. Simply export as a dynamic worksheet and unhide the hidden column at the end which is your GUIDs.
3 comments:
In CRM 2011 there should be an option to 'make this data available for reimporting...'. If ou select this option, one of the first three columns (which are hidden) has the guid for the record.
You know you've got a quality CRM consultant when you google a question and his blog comes up!
Post a Comment