E-mail database of suppliers

If you haven’t already captured the e-mail addresses of your supplier contacts, then here’s a good reason to do so. Once captured, you can use these addresses to e-mail a remittance advice instead of posting it, meaning no paper, printing or postage costs.

Addresses

Use our E-mail Database Of Suppliers to store the e-mail addressees of your supplier contacts.

Put the surname of the contact in column A and their first name in column B. When you type their e-mail address in column C Excel will automatically format the e-mail address as a hyperlink. This means that when you right-click on the address, an e-mail is automatically created/opened with the correct address in Outlook.

To keep this database up to date, ensure buyers ask for the contact e-mail addresses of all new suppliers.