Results 1 to 10 of 190

Thread: Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

Threaded View

DocAElstein Appendix Thread 2. ( ... 09-16-2015, 03:25 PM
DocAElstein Grid coordinates for a Range... 05-29-2016, 08:07 PM
DocAElstein More Named Range Scope Wonks.... 06-26-2016, 10:27 PM
DocAElstein Array List Sort of Referrences 10-23-2016, 02:19 PM
DocAElstein Code For Nelson 01-30-2017, 04:58 AM
DocAElstein Code for Nelson in this... 02-03-2017, 07:13 PM
DocAElstein Second Code for Nelson using... 02-05-2017, 07:02 PM
DocAElstein 'Testies: NOT FINAL CODE ---... 02-09-2017, 02:39 PM
DocAElstein Post 22 Before ( HTML ) 02-09-2017, 04:43 PM
DocAElstein Post 22 Before ( BB Code ) 02-09-2017, 04:46 PM
DocAElstein First macro attempt for this... 08-21-2023, 02:27 PM
DocAElstein Some extra notes for this... 10-08-2023, 06:45 PM
DocAElstein After from last two posts... 02-09-2017, 04:48 PM
DocAElstein HTML After using Sub... 02-09-2017, 04:57 PM
DocAElstein Totals output for last post (... 02-09-2017, 04:58 PM
DocAElstein Top Part of Code 4 for Nelson 02-09-2017, 05:05 PM
DocAElstein Sub... 02-09-2017, 05:10 PM
DocAElstein All Sub Folder and File List... 12-29-2017, 12:20 AM
DocAElstein Dumping Logs. Recurring... 02-07-2018, 03:49 PM
DocAElstein Per PM request: One full... 02-08-2018, 12:53 AM
DocAElstein complete-page-numbers ... 02-12-2018, 08:38 PM
DocAElstein Function CStrSepDbl Excel... 02-17-2018, 05:06 PM
DocAElstein VBA to automate Send and... 02-23-2018, 03:16 PM
DocAElstein VBA to automate Send and... 02-28-2018, 12:22 AM
DocAElstein Function Code for solution to... 02-28-2018, 12:37 AM
DocAElstein HTML Code seen in Text Editor 03-01-2018, 06:02 PM
DocAElstein Modified initial function and... 03-01-2018, 09:54 PM
DocAElstein Code for RaghavendraPrabhu ... 03-18-2018, 04:01 PM
DocAElstein Second Code for... 03-20-2018, 04:09 PM
DocAElstein Example VBA available checked... 03-22-2018, 01:29 PM
DocAElstein Results for RaghavendraPrabhu 03-23-2018, 12:48 PM
DocAElstein Final Results for Code 2b)... 03-24-2018, 02:17 PM
DocAElstein Code for last post Sub... 03-24-2018, 02:49 PM
DocAElstein Search for text in txt File... 03-28-2018, 12:48 AM
DocAElstein Using this File: ... 03-28-2018, 01:36 PM
DocAElstein Finding and deleteing .exd... 03-29-2018, 04:13 PM
DocAElstein Screenshots and extra notes... 04-02-2018, 02:00 PM
DocAElstein From last post... This... 04-02-2018, 02:01 PM
DocAElstein For this Post... 04-02-2018, 02:26 PM
DocAElstein From last Post... master File... 04-02-2018, 03:16 PM
DocAElstein Master File After First... 04-02-2018, 05:28 PM
DocAElstein Bottom part of worksheet... 04-02-2018, 05:47 PM
DocAElstein Some similar results to the... 04-02-2018, 05:44 PM
DocAElstein Typical Updated Data File,... 04-02-2018, 05:55 PM
DocAElstein Run Code Sub ExportByName()... 04-02-2018, 06:26 PM
DocAElstein “zMasterAfter1stConsolidationN... 04-02-2018, 06:15 PM
DocAElstein Corresponding updated data... 04-02-2018, 06:31 PM
DocAElstein Data Files just before second... 04-02-2018, 06:44 PM
DocAElstein Final results for first half... 04-02-2018, 06:55 PM
DocAElstein Second half of master... 04-02-2018, 06:57 PM
DocAElstein Data files after final... 04-02-2018, 07:01 PM
DocAElstein Code for anwser to this... 04-02-2018, 07:17 PM
DocAElstein Checked Library Infomation... 04-07-2018, 12:43 AM
DocAElstein Test data supplied by... 05-13-2018, 02:28 PM
DocAElstein Table from above again Using... 05-13-2018, 02:32 PM
DocAElstein Code for this Thread:... 05-13-2018, 02:40 PM
DocAElstein Another view of last table ... 05-13-2018, 02:31 PM
DocAElstein Re Post code with Code tags 05-24-2018, 01:24 PM
DocAElstein Code in code tags from here:... 06-02-2018, 11:30 AM
DocAElstein Share account for testing... 06-22-2018, 10:34 AM
DocAElstein Testing Hyperlinks in... 06-30-2018, 02:36 PM
DocAElstein Code for Thai . Option... 07-01-2018, 02:17 PM
DocAElstein First test code for solution... 07-07-2018, 01:37 PM
DocAElstein Test runs from code Sub... 07-19-2018, 02:24 PM
DocAElstein Code in support of this Post... 07-19-2018, 02:40 PM
DocAElstein Code in support of this Post... 07-23-2018, 03:57 PM
DocAElstein Code in support of this Post... 07-23-2018, 04:03 PM
DocAElstein Results in support of answer... 07-26-2018, 02:33 PM
DocAElstein Code corresponding to last... 07-26-2018, 02:43 PM
DocAElstein Suggested test data to answer... 07-29-2018, 11:51 AM
DocAElstein Code to answer this post:... 07-29-2018, 01:31 PM
DocAElstein Sample test results for code... 07-29-2018, 01:33 PM
DocAElstein In the last code , ( Sub... 07-29-2018, 12:00 PM
DocAElstein Code for alternative(2)... 07-30-2018, 12:38 PM
DocAElstein test results from code above,... 07-30-2018, 12:43 PM
DocAElstein Test data in support of this... 07-31-2018, 12:54 PM
DocAElstein Attaching a File to a Thread... 08-02-2018, 11:57 AM
DocAElstein In support of this Post... 08-02-2018, 12:18 PM
DocAElstein Loop through closed workbooks... 11-04-2018, 06:43 PM
DocAElstein Named Ranges scope defines... 11-11-2018, 03:47 PM
DocAElstein Further Practice with using... 11-18-2018, 06:03 PM
DocAElstein Second main Demo Code in... 11-18-2018, 06:06 PM
DocAElstein Support Called routines for... 11-18-2018, 06:08 PM
DocAElstein In support of this post: ... 11-18-2018, 06:21 PM
DocAElstein VBA named range scope not... 11-20-2018, 06:12 PM
DocAElstein NameObjectFile.xls as Zip 11-20-2018, 09:44 PM
DocAElstein ClsData.xls as Zip File 11-21-2018, 02:02 AM
DocAElstein Summary of info in the XML... 11-21-2018, 06:13 PM
DocAElstein A brief introduction to... 12-06-2018, 10:13 PM
DocAElstein Pubic Properly Leting Get in... 12-09-2018, 08:40 PM
DocAElstein Continuation fron last Post... 12-09-2018, 08:42 PM
DocAElstein Sub ... 12-24-2018, 01:10 PM
DocAElstein Sub... 12-24-2018, 01:12 PM
DocAElstein Sub... 12-24-2018, 01:16 PM
DocAElstein Code for Yassser here:... 12-30-2018, 08:47 PM
DocAElstein ' Sub... 12-31-2018, 12:43 AM
DocAElstein Code for suppot of this... 01-01-2019, 07:41 PM
DocAElstein 4, 5, 6 and 7 data section... 01-01-2019, 07:51 PM
DocAElstein First 3 section output after... 01-01-2019, 07:49 PM
DocAElstein Coding for Update Lists 01-09-2019, 09:11 PM
DocAElstein This is required for the... 01-09-2019, 09:29 PM
DocAElstein Part 2 of Main code. This... 01-09-2019, 09:27 PM
DocAElstein Appendix to .. 01-09-2019, 09:54 PM
DocAElstein Full demo code to accompany... 01-09-2019, 09:56 PM
DocAElstein Continued from last post ... 01-09-2019, 09:55 PM
DocAElstein Test Sort Routine 01-30-2019, 01:08 AM
DocAElstein Sub subArrayMergeSort( _ ... 01-30-2019, 01:18 AM
DocAElstein Routines called by test code... 01-30-2019, 01:18 AM
DocAElstein VBA Filter for Columns... 02-03-2019, 04:46 PM
DocAElstein Filter for columns not for... 02-03-2019, 04:52 PM
DocAElstein Simplified coding 02-03-2019, 08:06 PM
DocAElstein Sir Narios ... Positioning of... 02-05-2019, 08:44 PM
DocAElstein "What’s in a String"- VBA... 02-07-2019, 10:50 PM
DocAElstein This is the second part of... 02-07-2019, 10:52 PM
DocAElstein Simple Array Bubble Sort... 02-18-2019, 02:51 PM
DocAElstein Further Examples using the... 02-18-2019, 02:58 PM
DocAElstein Simpla Array Bubble Sort... 02-19-2019, 10:52 PM
DocAElstein Simple Array Bubble Sort... 02-19-2019, 11:55 PM
DocAElstein The sorted array is displayed... 02-20-2019, 12:12 AM
DocAElstein First step in turning Bubble... 02-20-2019, 10:28 PM
DocAElstein Because we are using ByRef ... 02-21-2019, 01:15 PM
DocAElstein Initial Function for Simple... 02-21-2019, 05:24 PM
DocAElstein Some typical resullts using... 02-21-2019, 05:47 PM
DocAElstein Final Demo of recursion array... 02-22-2019, 06:20 PM
DocAElstein Final Main recursion Array... 02-22-2019, 06:56 PM
DocAElstein Typical results using coding... 02-22-2019, 08:23 PM
DocAElstein Code to simulate Click on... 03-02-2019, 10:44 PM
DocAElstein Clear Windows ClIpboard 03-03-2019, 05:46 PM
DocAElstein Early Binding and Later Late... 03-03-2019, 09:16 PM
DocAElstein Sub TestieSimpleArraySort7() ... 03-13-2019, 09:38 PM
DocAElstein Main recursion routine ... 03-13-2019, 09:45 PM
DocAElstein Sub TestieSimpleArraySort8()... 03-14-2019, 03:52 PM
DocAElstein Sub SimpleArraySort8( 03-14-2019, 04:30 PM
DocAElstein Coding for this excelfox... 03-16-2019, 10:09 PM
DocAElstein Sub BubblesIndexIdeaWay As... 03-17-2019, 02:21 PM
DocAElstein Sub BubblesIndexIdeaWay As... 03-17-2019, 02:22 PM
DocAElstein Original test data range , (... 03-17-2019, 02:59 PM
DocAElstein Sub... 03-17-2019, 03:25 PM
DocAElstein Recursion routine for this... 03-17-2019, 08:23 PM
DocAElstein Some Killing File tests /... 03-31-2019, 02:31 PM
DocAElstein There is a second argument to... 04-02-2019, 03:17 PM
DocAElstein Deafault item to use if empty... 04-02-2019, 03:19 PM
DocAElstein Dir Order 04-02-2019, 03:16 PM
DocAElstein Coding in suport of these... 04-06-2019, 01:15 PM
DocAElstein Initial coding for solution... 04-20-2019, 03:10 PM
DocAElstein In support of answer to this... 04-21-2019, 03:06 PM
DocAElstein _____ Workbook: Data Sheet... 04-24-2019, 11:36 AM
DocAElstein August 1 2023 Back to this... 08-01-2023, 03:21 PM
DocAElstein August 1 2023 Back to this... 08-01-2023, 03:22 PM
DocAElstein August 1 2023 Back to this... 08-01-2023, 03:22 PM
DocAElstein In support of this thread ... 04-24-2019, 11:34 AM
DocAElstein August 1 2023 Back to this... 08-01-2023, 03:21 PM
DocAElstein _____ Workbook: FilTit.xlsm (... 08-22-2023, 10:05 AM
DocAElstein Second main macro attempt for... 08-22-2023, 10:18 AM
DocAElstein For later 08-22-2023, 10:09 AM
DocAElstein For this post: ... 08-22-2023, 10:32 AM
DocAElstein lateragain ... 08-23-2023, 03:17 PM
DocAElstein Some extended explanations... 08-24-2023, 01:45 PM
DocAElstein Rem 3 Filter out by loop ,... 08-25-2023, 05:21 PM
DocAElstein 4th macro, (macro explained... 08-25-2023, 06:09 PM
DocAElstein Test Copy Here is... 08-26-2023, 09:35 PM
DocAElstein A,jdcDS;HS lateragain 08-29-2023, 10:47 PM
DocAElstein Uploading files is not... 08-29-2023, 10:47 PM
DocAElstein Some extra notes for these... 01-17-2024, 03:09 AM
DocAElstein Some extra notes for these... 01-17-2024, 05:35 PM
DocAElstein Some extra notes for this... 01-18-2024, 10:41 PM
DocAElstein ' c509 c609 Windows... 01-19-2024, 01:53 AM
DocAElstein Some more notes for these... 01-20-2024, 06:37 PM
DocAElstein for later 01-20-2024, 06:30 PM
DocAElstein As example, after running the... 01-20-2024, 09:56 PM
DocAElstein Coding for this post: ... 01-22-2024, 03:25 AM
DocAElstein later 01-22-2024, 02:56 AM
DocAElstein This is post ... 01-22-2024, 08:49 PM
DocAElstein Some extended notes to go... 01-25-2024, 04:04 PM
DocAElstein l ... 01-25-2024, 04:16 PM
DocAElstein later 01-30-2024, 09:31 PM
DocAElstein and later again 01-30-2024, 09:31 PM
DocAElstein Some notes in support of this... 01-30-2024, 09:36 PM
DocAElstein I took another little time... 01-25-2024, 04:02 PM
DocAElstein To Demo: Put Folder, Movie... 01-25-2024, 04:02 PM
DocAElstein Some screen shots for this... 01-25-2024, 04:02 PM
DocAElstein Private Sub... 01-25-2024, 04:02 PM
DocAElstein Here is the main recursion /... 01-25-2024, 04:02 PM
DocAElstein Later kahhas 01-30-2024, 09:31 PM
DocAElstein Some stuff to save for... 03-16-2024, 01:16 PM
DocAElstein Some extra notes for these... 05-22-2024, 10:02 PM
DocAElstein Coding and possibly later... 12-28-2024, 02:32 PM
DocAElstein Coding for these main forum... 01-11-2025, 01:39 AM
DocAElstein Coding for this Post ... 02-05-2025, 11:48 PM
DocAElstein Coding for this main forum... 02-06-2025, 02:53 PM
Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10

    VBA to automate Send and Automatically Sending of E-Mails and Excel File Workbooks

    Further notes in support of answer to this Thread:
    http://www.excelfox.com/forum/showth...kbooks-at-once
    http://www.excelfox.com/forum/showth...0518#post10518


    Microsoft Outlook.
    WTF is that and HTF do you do anything with it, and WTF is it supposed to do.

    I didn't know. And still don't......
    The internet is full of stuff on this, but there is no clear explanation of what it is or what it should do or how you do anything with it.

    But I had a go
    Microsoft Outlook: what is that ( using manually )
    You would normally get the software to run on its own ( visible as it were ) in a similar way to which you might get Word or Excel to start, for example
    Find it single click on it:
    FindOutlook Start AllProgrammes Microsoft MicrosoftOutlook.JPG : https://imgur.com/LaGs6HA
    FindOutlook Start TypeInSearchBox Outlook.JPG : https://imgur.com/IbFOSHz
    Make a Desktop icon from a Copy/ paste and double click on it :
    MicrosoftOutlook Make a desktop Icon to double click on.JPG : https://imgur.com/ZNNPmOI

    The first time you try to open it with a click or two, a set up starts.
    Outlook2003Start.JPG https://imgur.com/tSQDoTe
    The main use of the Outlook software is to do Email stuff, so usually you will have at least one Email account “registered in it” You can do this at the set up or later.
    I had a go,
    the start was OK:
    Outlook2003Start.JPG https://imgur.com/R71pKfy
    Outlook2003Start2.JPG https://imgur.com/XUFMpEm

    These following steps took me a few hours of Emails, Internet surfing and annoying Telephone calls to my Internet provider before I
    _ chose IMAP here : Outlook2003Start3ServerType.JPG : https://imgur.com/Jmnd6Vb
    and
    _ got the two required things to put in the 2 server information bars, and other stuff to fill in this : Outlook2003Start4ServerConfiguration.JPG : https://imgur.com/NXNAt9J
    Code:
    Von: "Doc.AElstein@t-online.de" 
    An: "elston, alan" 
    Pop3
    *	Serveradresse	Port*	Sicherheit
    Posteingang	securepop.t-online.de	995	SSL / TLS
    Postausgang	securesmtp.t-online.de	465	SSL
    *
    E-Mails über IMAP4 abrufen
    *	Serveradresse	Port*	Sicherheit
    Posteingang	secureimap.t-online.de	993	SSL
    Postausgang	securesmtp.t-online.de	465	SSL
    
    From: "Doc.AElstein@t-online.de" 
    To: "elston, alan" 
    pop3
    Server address Port Security
    Inbox securepop.t-online.de 995 SSL / TLS
    Outbox securesmtp.t-online.de 465 SSL
    
    Retrieve emails via IMAP4
    Server address Port Security
    Inbox secureimap.t-online.de 993 SSL
    Outbox securesmtp.t-online.de 465 SSL
    Outlook2003Start4ServerConfiguration.JPG : https://imgur.com/NXNAt9J
    MyTelekomNameUsernamePassword.JPG : https://imgur.com/K6qZgsE
    TelekomInternetConfiguration.JPG : https://imgur.com/Z3XcsJu




    Then I hit Finish:
    Outlook2003Start5Fertig.JPG : https://imgur.com/wIMvqBb ´
    I get an error in the left Pane atz that point or later as well sometimes :
    Outlook2003Start6LeftpaneErrror.JPG : https://imgur.com/35XLQv6
    Code:
    could not connect to the server  secureimap t online.JPG : https://imgur.com/UqEZtQe 
    Fehler (0x800CCC0E) beim Ausführen der Aufgabe "Suchen nach neuen Nachrichten in den abonnierten Ordnern auf secureimap.t-online.de.": "Der Download des Ordners "(null)" von Konto "secureimap.t-online.de" vom IMAP-Mailserver ist fehlgeschlagen. Fehler: Die Verbindung zum Server konnte nicht hergestellt werden. Falls dieser Fehler weiterhin auftritt, wenden Sie sich an den Serveradministrator oder den Internetdienstanbieter."
    
    Fehler (0x800CCC0E) beim Ausführen der Aufgabe "secureimap.t-online.de: Posteingang - Auf neue E-Mail überprüfen.": "Der Download des Ordners "Posteingang" von Konto "secureimap.t-online.de" vom IMAP-Mailserver ist fehlgeschlagen. Fehler: Die Verbindung zum Server konnte nicht hergestellt werden. Falls dieser Fehler weiterhin auftritt, wenden Sie sich an den Serveradministrator oder den Internetdienstanbieter."
    
    
    
    
    
    Error (0x800CCC0E) while performing the task "Search for new messages in the subscribed folders on secureimap.t-online.de.": "Downloading the folder" (null) "from account" secureimap.t-online.de "from IMAP mail server failed Error: Unable to connect to server If this error persists, contact your server administrator or ISP. "
    
    Error (0x800CCC0E) when executing the task "secureimap.t-online.de: Inbox - Check for new e-mail.": "The download of the folder" Inbox "of account" secureimap.t-online.de "from IMAP- Mail server failed Error: Unable to connect to server If this error persists, contact your server administrator or ISP. "
    
    
    
    Every time I open Microsoft Outlook after that I get a pop up : could not connect to the server secureimap t online.JPG : https://imgur.com/UqEZtQe
    Code:
    Es Konnte keine Verbindung zum Server hergestellt werden. secureimap.t-online.de befindet sich jetzt im Offlinemodus
    
    It could not connect to the server. secureimap.t-online.de is now in offline mode
    So I am still none the wiser, but It is worth doing all that anyway as you may need some of that information later in one or more of the ways to send an Email using VBA.


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=oVb1RfcSHLM&lc=UgwTq-jZlZLnLQ5VB8Z4AaABAg.9Hroz-OyWog9tYjSMc1qjA
    https://www.youtube.com/watch?v=0pbsf6sox34&lc=Ugxp9JFvvejnqA68W1t4AaABAg
    https://www.youtube.com/watch?v=kfQC-sQxMcw&lc=UgyCxQWypNIhG2nUn794AaABAg.9q1p6q7ah839tUQl_92m vg
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg.9isY3Ezhx4j9itQLuif2 6T
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg.9irSL7x4Moh9itTRqL7d Qh
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg.9irLgSdeU3r9itU7zdnW Hw
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg.9iraombnLDb9itV80HDp Xc
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg.9is0FSoF2Wi9itWKEvGS Sq
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 09-22-2023 at 04:06 PM.

Similar Threads

  1. VBA to Reply All To Latest Email Thread
    By pkearney10 in forum Outlook Help
    Replies: 11
    Last Post: 12-22-2020, 11:15 PM
  2. Appendix Thread. Diet Protokol Coding Adaptions
    By DocAElstein in forum Test Area
    Replies: 6
    Last Post: 09-05-2019, 10:45 AM
  3. Replies: 19
    Last Post: 04-20-2019, 02:38 PM
  4. Search List of my codes
    By PcMax in forum Excel Help
    Replies: 6
    Last Post: 08-03-2014, 08:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •