> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.laposta.org/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.laposta.org/_mcp/server.

# Transferring addresses from an Outlook contact group to Excel

> Copy email addresses from a contact group or email message in Outlook and save them in an Excel file to import.

If you want to [import into Laposta](/hoe-importeer-ik-een-groot-relatiebestand) email addresses from Outlook, first place them in an Excel file. You can copy the addresses from a saved contact group or from an email message.

## Copying addresses from a saved contact group

#### Open your contacts in Outlook

Start Outlook and click the ‘People’ icon in the bottom left (or go via Home → People). Find the mailing group or contact group that you want to transfer.

#### Open the contact group

Double-click the group to open it in a new window.

#### Copy the email addresses

Select all members of the group, for example with `Ctrl+A`. Right-click and choose ‘Copy’.

> **Note**
>
> In some versions of Outlook, you first need to click ‘Members...’ or ‘Expand list’ to see and select the email addresses.

#### Paste the data into Excel

Open Excel, click cell `A1` and paste the data with `Ctrl+V`. The email addresses are now in your worksheet as text.

## Copying addresses from an email message

If the addresses are in the To, CC or BCC field of a received or sent email, you can copy them directly from there.

#### Open the email in Outlook

Open an email that contains multiple addresses.

#### Copy the addresses

Select all addresses in the field, right-click and choose ‘Copy’ (or use `Ctrl+C`). If you cannot select the addresses individually, first click ... → Show all fields, or double-click the field so that you can see the full list.

#### Paste the addresses into Excel

Open Excel, click cell `A1` and paste the data with `Ctrl+V`. Depending on the formatting, the addresses will appear in a single cell or across multiple rows.

## Splitting data into separate columns

If there are multiple pieces of data per row, such as a name and an email address together, place them in separate columns:

#### Open Text to Columns

In Excel, go to Data → Text to Columns.

#### Choose the delimiter

Choose ‘Delimited’ and select the delimiter, for example a comma or a semicolon.

#### Complete the split

Click ‘Finish’.

## Related articles

#### [Importing a file with subscribers from Excel or CSV](/hoe-importeer-ik-een-groot-relatiebestand)

Add new subscribers to your list all at once or update the data of your existing…

#### [Exporting subscribers to Excel](/kan-ik-mijn-relatiegegevens-eenvoudig-exporteren)

Download a list, segment or campaign result as an Excel file, including unsubscribed…

#### [Why were rows skipped during the import?](/hoe-weet-ik-het-resultaat-van-het-importeren-van-een-groot-relatiebestand)

After importing, you can see in step 4 how many subscribers have been added or updated…

#### [Importing existing contacts from PerfectView](/hoe-werkt-de-uitwisseling-van-gegevens)

Read which data the PerfectView integration transfers and how to import existing…