start:promomail
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
start:promomail [2017/04/06 10:12] andre [Outlook VB Macro to copy mail to folder] |
start:promomail [2017/04/19 15:55] (current) andre [Outlook VB Macro to copy mail to folder] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Promotional Email Settings ====== | ====== Promotional Email Settings ====== | ||
| - | ===== GMail account information ===== | + | ===== Email account information ===== |
| - | * orders.picnicpromotions@gmail.com | + | * picnicpromotions@ec2-54-219-159-220.us-west-1.compute.amazonaws.com |
| - | * [[start:promomailcred|Credentials]] | + | * [[start:promoemailcred|Credentials]] |
| - | * [[http://pop2imap.com/gmail-outlook-2010.php|Add Your Gmail Account to Outlook 2010 Using IMAP]] | + | * [[http://pop2imap.com/gmail-outlook-2010.php|Add email account to Outlook 2010 Using IMAP]] |
| * Server settings (manually configure in Outlook 2010) | * Server settings (manually configure in Outlook 2010) | ||
| - | * Incoming mail server: ''imap.gmail.com'' | + | * Incoming mail server: ''ec2-54-219-159-220.us-west-1.compute.amazonaws.com'' |
| * Outgoing mail server: ''smtp.DoNotUse.com'' (email should only be sent from Picnic Time email addresses) | * Outgoing mail server: ''smtp.DoNotUse.com'' (email should only be sent from Picnic Time email addresses) | ||
| - | * Server port number for incoming server (IMAP): ''993'' (Outlook 2010 More settings ... Advanced) | + | * Server port number for incoming server (IMAP): ''143'' (Outlook 2010 More settings ... Advanced) |
| - | * Incoming server encrypted connection: ''SSL'' (Outlook 2010 More settings ... Advanced) | + | * Incoming server encrypted connection: ''TLS'' (Outlook 2010 More settings ... Advanced) |
| ===== Outlook VB Macro to copy mail to folder ===== | ===== Outlook VB Macro to copy mail to folder ===== | ||
| + | * [[https://msdn.microsoft.com/en-us/library/office/ee814736(v=office.14).aspx|Getting Started with VBA in Outlook 2010]] | ||
| * To open the Visual Basic Editor in Outlook 2010 | * To open the Visual Basic Editor in Outlook 2010 | ||
| * Click the Macros button on the Developer tab. | * Click the Macros button on the Developer tab. | ||
| - | * In the Macro dialog box that appears, type CopyToGmail under Macro Name. | + | * In the Macro dialog box that appears, type CopyToCould under Macro Name. |
| * Click the Create button to open the Visual Basic Editor with the outlines of a new macro already typed in. | * Click the Create button to open the Visual Basic Editor with the outlines of a new macro already typed in. | ||
| * Copy, paste and save the VBA code below into the Visual Basic Editor: | * Copy, paste and save the VBA code below into the Visual Basic Editor: | ||
| <code>'Outlook VB Macro to copy selected mail item(s) to a target folder | <code>'Outlook VB Macro to copy selected mail item(s) to a target folder | ||
| - | Sub CopyToGmail() | + | Sub CopyToCloud() |
| On Error Resume Next | On Error Resume Next | ||
| Line 27: | Line 29: | ||
| 'Define path to the target folder | 'Define path to the target folder | ||
| - | Set CopyToFolder = ns.Folders("orders.picnicpromotions@gmail.com").Folders("Inbox") | + | Set CopyToFolder = ns.Folders("picnicpromotions@ec2-54-219-159-220.us-west-1.compute.amazonaws.com").Folders("Inbox") |
| If Application.ActiveExplorer.Selection.Count = 0 Then | If Application.ActiveExplorer.Selection.Count = 0 Then | ||
| Line 53: | Line 55: | ||
| End Sub | End Sub | ||
| </code> | </code> | ||
| + | ===== Add Macro buttons in Outlook 2010 ===== | ||
| + | * [[https://msdn.microsoft.com/en-us/library/office/ee814736(v=office.14).aspx#sectionSection3|Create a button for the macro on the Quick Access Toolbar]] | ||
| + | * To create a button for a macro on the Quick Access Toolbar | ||
| + | * Click the File tab. | ||
| + | * Click Options to open the Outlook Options dialog box, and then click Quick Access Toolbar. | ||
| + | * In the list under Choose commands from:, choose Macros. Find the text that is similar to Project1.Module1.Test in the list that appears and select that text. | ||
| + | * Click the Add >> button to add the macro to the list on the right side, and then click the Modify… button to select a button image to associate with the macro. | ||
| + | * Click OK. You should see your new button on the Quick Access Toolbar above the File tab. | ||
| + | * Now you can quickly run your macro at any time without using the Developer tab—give it a try. | ||
start/promomail.1491498754.txt.gz · Last modified: 2017/04/06 10:12 by andre
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
