If you don’t want to set up an FTP server and you do want to save saved search results locally, read on.
Here are the steps:
- Create a saved search that returns less than 10,000 records or 5 Megs. That’s the limit when emailing results.
- Set your saved search to send to a recipient with Outlook running on a computer in your network. Sorry… this won’t work with an Exchange rule.
- Set the email to go out on whatever frequency you like.
- Customize the email so that you can identify it when it arrives in outlook as the email you’d like to save attachments.
- Check out this link to install a macro that runs in Outlook that downloads attachments.
https://community.spiceworks.com/scripts/show/361-auto-save-attachments-to-folder
- On the Outlook client that will receive the email from NetSuite, go to
File >> Options >> Customize Ribbon
Check the Developer tab
- Unfortunately, you’ll need to enable all macros.
- Open Macros by clicking “Visual Basic Editor”
- Paste in the VB code you downloaded in step 5. You must paste it into the “ThisOutlookSession” object in the left nav.
Note that I’ve set up my macro to download attachments on any incoming email that has a subject of “Exported ITEMS.” I’m saving the attachment to a network folder. Don’t miss the note to add make sure you have an ending backslash on the path!
- Once you close and save this macro, close and re-open Outlook.
- To test, I simply ran my saved search. Emailed it to myself using the Email icon on the search results. When the email arrived, I changed the subject to “Exported ITEMS” and forwarded it to myself. I checked the network folder and my search results were there.
- The next step for me would be to create a job in my SQL server to auto-import the results into a table in my database.