======How to move messages between users======

There are several ways to do this, depending on your exact needs

=====Via Administrator Console=====
You can view a user's 'Inbox' messages by clicking on the message count on the **Users** list, then select the messages, choose the target user, and press the **Move** or **Copy** button

In version 5 you can view messages from folders other than the 'Inbox' folder, but only move them to the target user's Inbox. In earlier versions of VPOP3 you can only view & move messages from the 'Inbox' folder.
=====Via an email client=====
This only works with VPOP3 Enterprise.

The easiest way is to configure the email client to access both accounts using IMAP4, and drag the folders/messages from one account to the other. Note that this will require the email client to download the message from the first account, then upload it to the second, so may be time consuming for moving large numbers of messages.

An alternative is to [[IMAP folder sharing|share the target user's folders]] with the source user, and then drag the messages across within the one account. This is a lot quicker since the email client just issues an IMAP4 'COPY' command to VPOP3, rather than having to download all the messages, then upload them again.

=====Direct database access=====
**Note that this is only for very advanced users, and we do not offer support for this method - if you mess up your message store, or lose messages because of doing this, that is your own responsibility**. If you want us to do this for you, then we are able to do it remotely as part of a [[http://www.pscs.co.uk/buynow/buy.php?item=MISCPHONE|chargeable support call (£20 + VAT)]]

This method just allows you to move entire folders between users.

Note that the instructions below are for VPOP3 versions 3 to 5, and do not apply to earlier versions, and may change in later versions. 

  - [[Stop VPOP3]]
  - **//__[[Backup VPOP3]]__//**
  - Go to a command prompt, and go to the **VPOP3\pgsql\bin** folder on the disk
  - Run **psql -U vpop3 vpop3** (default password is **vpop3pass**)
  - Type **SELECT * FROM users.users;** - find the source and target users and note their **usernumber** values (they will be called //<sourceuser>// and //<targetuser>// in the remainder of the instructions
  - If you want to move ALL folders from the source user, and lose all existing folders for the target user:
      - type **DELETE FROM messages.folders where userid=//<targetuser>//;**
      - type **UPDATE messages.folders SET userid=//<targetuser>// WHERE userid=//<sourceuser>//;**
  - If you want to move ALL folders from the source user, keep all existing folders for the target user, but call the moved folders "moved_<original name>":
      - type **UPDATE messages.folders SET userid=//<targetuser>//, folder= 'moved_' || folder WHERE userid=//<sourceuser>//;**
  - If you want to move a single folder from the source user, and rename it for the target user:
      - type **SELECT folderid FROM messages.folders WHERE userid=//<sourceuser>// AND folder='<folder name>';** (note the folderid)
      - type **UPDATE messages.folders set userid=//<targetuser>//,folder='<new folder name>' WHERE folderid=<folderid from previous step>;**
  - [[Start VPOP3|Restart VPOP3]]

Do NOT skip the [[Backup VPOP3]] step - it is very easy to go  wrong doing this, and you wouldn't want to lose all your messages!

You may need to delete and re-create the IMAP account in the email client to have it load the new folders correctly (or have it reload all the folders if the email client supports that option - Outlook doesn't)