# Export Task Notes for contacts with specific Tags **URL:** \ **Category:** Max Classic\ **Created:** [April 1, 2020, 5:48pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824 "2020-04-01T17:48:13Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Jacki\_Alberico](https://avatars.discourse-cdn.com/v4/letter/j/a9a28c/32.png) [@Jacki\_Alberico](https://integration.keap.com/u/Jacki_Alberico)\ **Post date:** [April 1, 2020, 5:48pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/1 "2020-04-01T17:48:13Z")
We have a list of 1,025 contacts who we’ve applied a specific set of Tags to. We want to export the Task Notes for just these contacts. I’ve chatted with support and i’m currently on hold with advanced tech support and they’re looking to see if this can be done. Unfortunately you can’t select specific Tags in the Task Notes Report. Anyone know of a way for this to be done? Thanks! ---
**Author:** ![Jeff\_Arnold](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/jeff_arnold/32/14802_2.png) [@Jeff\_Arnold](https://integration.keap.com/u/Jeff_Arnold)\ **Post date:** [April 1, 2020, 6:08pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/2 "2020-04-01T18:08:28Z")
If you don’t use the Fax2 field, you could select all your tagged folks, do a ‘bulk edit’ and set that to a specific field. Then, do your Task Report and export all values - be sure to include Fax2. Then, sort your sheet by Fax2 to choose all of those people who have your criteria. If you use Fax2 and can’t do the above, you are probably going to have to do some Excel magic. Export all the tagged folks (all you need is the ContactID). Then export all your Task Notes. Then setup and run Index/Match using Excel to identify those Notes that belong to the people who are tagged. [https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/](https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/) Hope that helps. Jeff ![email-sig-storybrand-certified-guide-60.png](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/b/b44e0b32c05e44619132d27268e14026b37d77b0.png) ---
**Author:** ![Jacki\_Alberico](https://avatars.discourse-cdn.com/v4/letter/j/a9a28c/32.png) [@Jacki\_Alberico](https://integration.keap.com/u/Jacki_Alberico)\ **Post date:** [April 7, 2020, 3:22pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/3 "2020-04-07T15:22:25Z")
Thanks so much for your suggestion. I’m sorry but I’m unsure how to do a “bulk edit”. I have the list and have selected all contacts but under Actions I do not see an option for “bulk edit”. Is this possibly called something else? Also, can you possibly reply to [twojdon@pfgiusa.com](mailto:twojdon@pfgiusa.com) please. Thanks again. ---
**Author:** ![Jeff\_Arnold](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/jeff_arnold/32/14802_2.png) [@Jeff\_Arnold](https://integration.keap.com/u/Jeff_Arnold)\ **Post date:** [April 7, 2020, 3:35pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/4 "2020-04-07T15:35:00Z")
It is ‘mass update contacts’ - here is where it is after you do the contacts search ![Screen Shot 2020-04-07 at 8.34.06 AM.png](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/4/4c1a6ef553260601abfdfd44e2c65c7281a0454c.png) ![email-sig-storybrand-certified-guide-60.png](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/b/b44e0b32c05e44619132d27268e14026b37d77b0.png) ---
**Author:** ![Jeff\_Arnold](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/jeff_arnold/32/14802_2.png) [@Jeff\_Arnold](https://integration.keap.com/u/Jeff_Arnold)\ **Post date:** [April 7, 2020, 6:46pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/5 "2020-04-07T18:46:37Z")
Here is a spreadsheet that you can use to do a combination of IF statements and CONCATENATE to merge the data The final column “KEEP” — is the one that will determine what you’ll keep at the end. After putting in these formulas and applying to the whole spreadsheet, click in the top left corner of the spreadsheet to select the whole thing, then copy and ‘paste special - values’ so that it pastes on the values (not formulas). Then, sort by the “KEEP” column so you get all the ‘keep’ data at the top, then delete all the stuff down below (where the KEEP value = no). That will give you your final value of what to keep as far as the Notes for each contact ID (Attachment merge Infusionsoft notes.xlsx is missing) ![email-sig-storybrand-certified-guide-60.png](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/b/b44e0b32c05e44619132d27268e14026b37d77b0.png) ---
**Author:** ![Jeff\_Arnold](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/jeff_arnold/32/14802_2.png) [@Jeff\_Arnold](https://integration.keap.com/u/Jeff_Arnold)\ **Post date:** [April 7, 2020, 6:48pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/6 "2020-04-07T18:48:27Z")
[merge Infusionsoft notes.xls](https://integration.keap.com/uploads/short-url/sVSBky48Dwe3B9DUPNPgU7A2NNu.xls) (27 KB) here is the attachment - didn’t’ come through via email * * * Jeff Arnold 4Spot Marketing • [4SpotMarketing.com](http://4SpotMarketing.com) 11700 W Charleston #170-160 • Las Vegas • NV • 89135 O: 702-721-9763 • C: 702-525-9763 [Client Testimonials](http://4spotmarketing.org/client-testimonials/) • [**Book an Appointment**](http://4spotmarketing.com/schedule-appointment/) For support related questions, please contact: General Support: [Support@4SpotMarketing.com](mailto:Support@4SpotMarketing.com) ---
**Author:** ![Jacki\_Alberico](https://avatars.discourse-cdn.com/v4/letter/j/a9a28c/32.png) [@Jacki\_Alberico](https://integration.keap.com/u/Jacki_Alberico)\ **Post date:** [April 8, 2020, 3:19pm UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/7 "2020-04-08T15:19:11Z")
Wow, thanks so much for your help. I really appreciate it. ---
**Author:** ![Jeff\_Arnold](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/jeff_arnold/32/14802_2.png) [@Jeff\_Arnold](https://integration.keap.com/u/Jeff_Arnold)\ **Post date:** [April 9, 2020, 12:24am UTC](https://integration.keap.com/t/export-task-notes-for-contacts-with-specific-tags/75824/8 "2020-04-09T00:24:25Z")
you are welcome ![email-sig-storybrand-certified-guide-60.png](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/b/b44e0b32c05e44619132d27268e14026b37d77b0.png)