Your E-junkie Transaction Log can be downloaded as a tab-delimited text file, with the Shipping addresses comma-delimited within. Once you download that file, here's how you can extract names and addresses suitable for a mailing list:
- Open the log file in a spreadsheet program like Excel, iWork Numbers, LibreOffice Calc, or Gnumeric;
- Select the entire column of Shipping addresses (just click on the header letter of the column, e.g. Column R) and Copy;
- Open a new plain text file -- e.g., using Notepad (Windows) or TextEdit (Mac, in plain text mode);
- Paste the shipping addresses into that file;
- Save that file with a name ending in
- Open that CSV file in your spreadsheet program;
- Select the first two columns and go to Insert > Column to get two new, blank columns;
- Switch back to your original log file spreadsheet;
- Select the entire Firstname & Lastname columns and Copy;
- Switch back to the CSV file spreadsheet and then Paste the names into the first two columns;
- Save that CSV file spreadsheet;
- The format of the resulting CSV file should be suitable for most mailing-list import routines.
As another alternative, if you're a programmer or wish to hire one, you can use our custom/3rd-party Integration feature to forward the order data to a custom script that saves the addresses for you in whatever format you wish directly; however, this would not capture address data from past orders, only new orders as they occur. See the Developer Directory link at the top of our site for a list of competent, E-junkie-experienced developers available for hire.