Script to extract and collate amazon voucher URLs in a CSV file, from individual emails exported from Outlook. Supports old and new Outlook for Windows, and new Outlook for Mac.
- Download the latest version of extract_links.exe from the releases page: https://github.com/Nottingham-CTU/amazon_extractor/releases
- Create a folder on your PC and drag the voucher emails from Outlook into the folder
- Open extract_links.exe
- Click ‘Select folder’
- Navigate to the folder you created earlier, which contains the emails
- Click ‘Select folder’
- Follow the instructions in the dialog prompts
- A CSV file will be created in the same folder as the emails
Make sure you have python 3 installed
- cd into the repo directory if not there already
- Create a python virtual environment to manage dependences:
python -m venv extractor_env
- Activate the virtual environment:
extractor_env\Scripts\activate
- Install the dependencies with pip:
pip install beautifulsoup4 lxml extract_msg pyinstaller
To run on your development machine:
python extract_links.py
To bundle as a Windows .exe for TM team to use:
pyinstaller --onefile --noconsole extract_links.py