Grafische Zwischenablage in Mail einfügen -

<!DOCTYPE html> <html dir="ltr" lang="de"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>Grafische Zwischenablage in Mail einfügen - </title> <link rel="alternate" type="application/atom+xml" title="Feed - " href="/app.php/feed?sid=18f95990791d43b3ba8ad966ef67ee0a"> <link rel="alternate" type="application/atom+xml" title="Feed - Neue Themen" href="/app.php/feed/topics?sid=18f95990791d43b3ba8ad966ef67ee0a"> <link rel="alternate" type="application/atom+xml" title="Feed - Forum - Microsoft Outlook" href="/app.php/feed/forum/5?sid=18f95990791d43b3ba8ad966ef67ee0a"> <link rel="alternate" type="application/atom+xml" title="Feed - Thema - Grafische Zwischenablage in Mail einfügen" href="/app.php/feed/topic/664?sid=18f95990791d43b3ba8ad966ef67ee0a"> <link rel="canonical" href="https://www.vbasteleien.de/viewtopic.php?t=664">  <link href="./assets/css/font-awesome.min.css?assets_version=53" rel="stylesheet"> <link href="./styles/prosilver/theme/stylesheet.css?assets_version=53" rel="stylesheet"> <link href="./styles/prosilver/theme/de/stylesheet.css?assets_version=53" rel="stylesheet">  <meta name="description" content="" /> <meta name="keywords" content="" /> <link rel="mask-icon" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/safari-pinned-tab.svg" color="#5bbad5"> <link rel="shortcut icon" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/favicon.ico"> <link rel="apple-touch-icon" sizes="180x180" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/favicon-16x16.png"> <meta name="msapplication-TileImage" content="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/ms-icon-144x144.png"> <link rel="manifest" href="https://www.vbasteleien.de/ext/chris1278/metainfo/styles/all/favinfo/site.webmanifest"> <meta name="msapplication-TileColor" content="#da532c"> <meta name="msapplication-config" content="https://www.vbasteleien.de/ext/chris1278/metainfo/styles/all/favinfo/browserconfig.xml"> <meta name="theme-color" content="#ffffff"> <link href="./ext/crizzo/aboutus/styles/prosilver/theme/aboutus.css?assets_version=53" rel="stylesheet" media="screen" /> <link href="./ext/kasimi/postnumbers/styles/prosilver/theme/postnumbers.css?assets_version=53" rel="stylesheet" media="screen" /> <link href="./ext/vse/abbc3/styles/all/theme/abbc3_common.min.css?assets_version=53" rel="stylesheet" media="screen" /> </head> <body id="phpbb" class="nojs notouch section-viewtopic ltr "> <div id="wrap" class="wrap"> <a id="top" class="top-anchor" accesskey="t"></a> <div id="page-header"> <div class="headerbar" role="banner"> <div class="inner"> <div id="site-description" class="site-description"> <a id="logo" class="logo" href="https://VBAsteleien.de" title="Startseite"> <span class="site_logo"></span> </a> <h1></h1> <p>VBAsteln makes the world go around ...</p> <p class="skiplink"><a href="#start_here">Zum Inhalt</a></p> </div> <div id="search-box" class="search-box search-header" role="search"> <form action="./search.php?sid=18f95990791d43b3ba8ad966ef67ee0a" method="get" id="search"> <fieldset> <input name="keywords" id="keywords" type="search" maxlength="128" title="Suche nach Wörtern" class="inputbox search tiny" size="20" value="" placeholder="Suche…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=18f95990791d43b3ba8ad966ef67ee0a" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="sid" value="18f95990791d43b3ba8ad966ef67ee0a" /> </fieldset> </form> </div> </div> </div> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-main" class="nav-main linklist" role="menubar"> <li id="quick-links" class="quick-links dropdown-container responsive-menu" data-skip-responsive="true"> <a href="#" class="dropdown-trigger"> <i class="icon fa-bars fa-fw" aria-hidden="true"></i><span>Schnellzugriff</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents" role="menu"> <li class="separator"></li> <li> <a href="./search.php?search_id=unanswered&sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-file-o fa-fw icon-gray" aria-hidden="true"></i><span>Unbeantwortete Themen</span> </a> </li> <li> <a href="./search.php?search_id=active_topics&sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-file-o fa-fw icon-blue" aria-hidden="true"></i><span>Aktive Themen</span> </a> </li> <li class="separator"></li> <li> <a href="./search.php?sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span>Suche</span> </a> </li> <li class="separator"></li> <li> <a href="./memberlist.php?sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-group fa-fw" aria-hidden="true"></i><span>Mitglieder</span> </a> </li> <li> <a href="./memberlist.php?mode=team&sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="separator"></li> <li> <a href="/app.php/thankslist?sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-thumbs-o-up fa-fw" aria-hidden="true"></i><span>Liste der Danksagungen</span> </a> </li> </ul> </div> </li> <li data-skip-responsive="true"> <a href="/app.php/help/faq?sid=18f95990791d43b3ba8ad966ef67ee0a" rel="help" title="Häufig gestellte Fragen" role="menuitem"> <i class="icon fa-question-circle fa-fw" aria-hidden="true"></i><span>FAQ</span> </a> </li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=login&redirect=viewtopic.php%3Fp%3D2034&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Anmelden" accesskey="x" role="menuitem"> <i class="icon fa-power-off fa-fw" aria-hidden="true"></i><span>Anmelden</span> </a> </li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=register&sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-pencil-square-o fa-fw" aria-hidden="true"></i><span>Registrieren</span> </a> </li> </ul> <ul id="nav-breadcrumbs" class="nav-breadcrumbs linklist navlinks" role="menubar"> <li class="breadcrumbs" itemscope itemtype="https://schema.org/BreadcrumbList"> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="https://VBAsteleien.de" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span itemprop="name">Startseite</span></a><meta itemprop="position" content="1" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="./index.php?sid=18f95990791d43b3ba8ad966ef67ee0a" accesskey="h" data-navbar-reference="index"><span itemprop="name">VBAsteleien.de -Foren-Übersicht-</span></a><meta itemprop="position" content="2" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="5"><a itemprop="item" href="./viewforum.php?f=5&sid=18f95990791d43b3ba8ad966ef67ee0a"><span itemprop="name">Microsoft Outlook</span></a><meta itemprop="position" content="3" /></span> </li> <li class="rightside responsive-search"> <a href="./search.php?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Zeigt die erweiterten Suchoptionen an" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </a> </li> </ul> </div> </div> </div> <a id="start_here" class="anchor"></a> <div id="page-body" class="page-body" role="main"> <h2 class="topic-title"><a href="./viewtopic.php?t=664&sid=18f95990791d43b3ba8ad966ef67ee0a">Grafische Zwischenablage in Mail einfügen</a></h2>  <div style="display: none !important;">Das Rohrpost-System aus Redmond dürfte wohl eines der wichtigsten Kommunikationssysteme weltweit sein. Leider können schon ein Versionswechsel oder die Umstellung von IMAP auf POP zu herben Datenverlusten führen. BackUps sind nirgends wichtiger als hier.<br /></div> <div class="action-bar bar-top"> <a href="./posting.php?mode=reply&t=664&sid=18f95990791d43b3ba8ad966ef67ee0a" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./memberlist.php?mode=email&t=664&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Thema weiterempfehlen"> <i class="icon fa-envelope-o fa-fw" aria-hidden="true"></i><span>Thema weiterempfehlen</span> </a> </li> <li> <a href="./viewtopic.php?t=664&sid=18f95990791d43b3ba8ad966ef67ee0a&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <div class="search-box" role="search"> <form method="get" id="topic-search" action="./search.php?sid=18f95990791d43b3ba8ad966ef67ee0a"> <fieldset> <input class="inputbox search tiny" type="search" name="keywords" id="search_keywords" size="20" placeholder="Thema durchsuchen…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=18f95990791d43b3ba8ad966ef67ee0a" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="t" value="664" /> <input type="hidden" name="sf" value="msgonly" /> <input type="hidden" name="sid" value="18f95990791d43b3ba8ad966ef67ee0a" /> </fieldset> </form> </div> <div class="pagination"> 10 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div id="p2006" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2006"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=18f95990791d43b3ba8ad966ef67ee0a">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=18f95990791d43b3ba8ad966ef67ee0a">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2006"> <h3 class="first"> <a href="./viewtopic.php?p=2006&sid=18f95990791d43b3ba8ad966ef67ee0a#p2006">Grafische Zwischenablage in Mail einfügen</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2006/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2006&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2006" title="Kopiert den Beitragslink in die Zwischenablage">#1</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2006&sid=18f95990791d43b3ba8ad966ef67ee0a#p2006" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-01-01T15:07:22+00:00">1. Jan 2025, 16:07</time> </p> <div class="content">Moin allerseits,<br> <br> einfach, weil es nicht einfach ist und weil es an anderer Stelle gefragt wurde (bisher nicht zielführend beantwortet): Hier eine VBA-Version für folgendes Szenario:<br> Der grafische Inhalt des Clipboards soll per VBA am Cursor einer OL-Mail eingefügt werden und in >step 2< in Größe und Zuschnitt bearbeitet werden.<br> <br> <strong class="text-strong">Erst mal die Basics für VBA in OL:</strong><br> <em class="text-italics">Outlook öffnen > Datei > Optionen > Menüband anpassen > Klassisches Menüband anpassen > Entwicklertools aktivieren.</em><br> Jetzt steht der VBE entweder über dem Punkt <em class="text-italics">Makros</em> im neuen Tab oder über <em class="text-italics">Alt+F11</em> bzw. <em class="text-italics">Alt+F8</em> zur Verfügung.<br> <br> Um den Verweis <em class="text-italics">Microsoft Forms 2.0 Object Library </em>zu aktivieren, der zumindest in meinem OL 2021 nicht verfügbar war, hilft dieser Trick: Im VBE eine Userform einfügen, das Projekt mit<em class="text-italics"> Strg+s </em>speichern und die USF wieder entfernen.<br> <br> <strong class="text-strong">Nun zu step 1:</strong><br> An geeigneter Stelle ein Verzeichnis <em class="text-italics">ClipBoard </em>anlegen. Es wird später maximal eine Datei enthalten.<br> Im VBE ein neues Modul <em class="text-italics">mdl_ClipToMail</em> anlegen und den folgenden Code oben einfügen. Es sind die API-Funktionen, die das ClipBoard auslesen und in ein Bildobjekt schreiben.<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Option Explicit Declare PtrSafe Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long Declare PtrSafe Function GetClipboardData Lib "user32" (ByVal wFormat As Long) As Long Declare PtrSafe Function CloseClipboard Lib "user32" () As Long Declare PtrSafe Function OleCreatePictureIndirect Lib "olepro32.dll" (PicDesc As PicBmp, RefIID As GUID, ByVal fPictureOwnsHandle As Long, IPic As IPicture) As Long Type GUID Data1 As Long: Data2 As Integer: Data3 As Integer: Data4(0 To 7) As Byte End Type Type PicBmp Size As Long: Type As Long: hBmp As Long: hPal As Long: Reserved As Long End Type</code></pre></div> Auf diese Funktionen greift die erste <em class="text-italics">Sub SaveClipToPic()</em> zu<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Private Sub SaveClipToPic() Dim hBitmap As Long, sPath As String, Pic As PicBmp, IPic As IPicture Dim IID_IDispatch As GUID sPath = "C:\Users\hbri\Desktop\ClipBoard\Datei.bmp" If OpenClipboard(0&) Then hBitmap = GetClipboardData(2) ' 2 = CF_BITMAP If hBitmap <> 0 Then With Pic .Size = Len(Pic) .Type = 1 ' Bildtyp .hBmp = hBitmap .hPal = 0 .Reserved = 0 End With With IID_IDispatch .Data1 = &H20400 .Data4(0) = &HC0 .Data4(7) = &H46 End With OleCreatePictureIndirect Pic, IID_IDispatch, True, IPic SavePicture IPic, sPath MsgBox "Bild erfolgreich gespeichert unter: " & sPath Else MsgBox "Die Zwischenablage enthält kein Bild." End If CloseClipboard Else MsgBox "Die Zwischenablage konnte nicht geöffnet werden." End If End Sub</code></pre></div> Der dritte Codeblock holt die Bitmap-Datei in den Cursor in einer geöffneten Mail. <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Private Sub InsertPicAtCursor() Dim objMail As Outlook.MailItem, objInspector As Outlook.Inspector Dim objDoc As Object, objSelection As Object, sPath As String sPath = "C:\Users\hbri\Desktop\ClipBoard\Datei.bmp" Set objMail = Application.ActiveInspector.CurrentItem Set objInspector = objMail.GetInspector Set objDoc = objInspector.WordEditor Set objSelection = objDoc.Application.Selection objSelection.InlineShapes.AddPicture sPath, False, True MsgBox "Bild erfolgreich eingefügt!" End Sub</code></pre></div> Letzter Schnipsel fürs Makro-Menü:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Sub ClipToMail() SaveClipToPic InsertPicAtCursor End Sub</code></pre></div> Jetzt steht unter Alt-F8 die letzte Sub zum Aufruf zur Verfügung. Noch mal zum Ablauf:<br> Neue Mail anlegen oder Clipboard mit Screenshot füllen (hier ist die Reihenfolge egal)<br> Cursor positionieren<br> Mit Alt+F8 <em class="text-italics">ClipToMail </em>aufrufen.<br> <br> step 2 wird dann eine automatische Formatierung des Pics sein. Dazu warte ich aber erst einmal auf Rückmeldungen zu step 1.<br> <br> Als Ergänzung: Statt grafischem Inhalt, kann natürlich auch Text übergeben werden, kann OL auch noch geschlossen sein und in eine neue Mail schreiben, und die Übergabe aus anderen OFF-Anwendungen erfolgen. Falls gewünscht.<br> <br> Schöne Grüße!</div> <div id='list_thanks2006'> </div> <div id='div_post_reput2006'> </div> <div id="sig2006" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2007" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile2007"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=18f95990791d43b3ba8ad966ef67ee0a">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=18f95990791d43b3ba8ad966ef67ee0a">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2007"> <h3 > <a href="./viewtopic.php?p=2007&sid=18f95990791d43b3ba8ad966ef67ee0a#p2007">Re: Grafische Zwischenablage in Mail einfügen >step 2<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2007/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2007&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2007" title="Kopiert den Beitragslink in die Zwischenablage">#2</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2007&sid=18f95990791d43b3ba8ad966ef67ee0a#p2007" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-01-01T19:19:37+00:00">1. Jan 2025, 20:19</time> </p> <div class="content">So - Freunde der spannenden Ideen!<br> <br> Hier nun also step 2 - also die proportionale Anpassung der eingefügten Grafik. Dazu ist ein dritter Codeblock und eine Anpassung in einem der vorherigen notwendig. Die Anpassung der <em class="text-italics">jeweils letzten</em> Grafik in einer Mail auf 200 px / 5 cm Breite (das hängt von der Bildschirmauflösung ab und geht hier von 96 px/inch aus) funktioniert so: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Private Sub SetPicSize() Dim oMail As MailItem, oInspector As Inspector Dim oDoc As Object, oShape As Object, dbRation As Double Dim dbWidth As Double, dbHeight As Double Set oMail = Application.ActiveInspector.CurrentItem Set oInspector = Application.ActiveInspector Set oDoc = oInspector.WordEditor Set oShape = oDoc.InlineShapes(oDoc.InlineShapes.Count) dbRation = oShape.Height / oShape.Width dbWidth = 200 dbHeight = dbWidth * dbRation oShape.Width = dbWidth oShape.Height = dbHeight End Sub</code></pre></div> Ich habe auch die Codes von oben noch einmal überarbeitet (unnötige MsgBoxen eliminiert, die motzen jetzt nur noch bei Fehlern, Nomenklatur standarisiert) und für die Integration des eigentliche dritten Schritts angepasst. <br> <strong class="text-strong"></strong><div style="text-align:center"><strong class="text-strong">Man kann also den Code im mdlClipToMail vollständig durch diesen ersetzen:</strong></div> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Option Explicit Declare PtrSafe Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long Declare PtrSafe Function GetClipboardData Lib "user32" (ByVal wFormat As Long) As Long Declare PtrSafe Function CloseClipboard Lib "user32" () As Long Declare PtrSafe Function OleCreatePictureIndirect Lib "olepro32.dll" (PicDesc As PicBmp, RefIID As GUID, ByVal fPictureOwnsHandle As Long, IPic As IPicture) As Long Type GUID Data1 As Long: Data2 As Integer: Data3 As Integer: Data4(0 To 7) As Byte End Type Type PicBmp Size As Long: Type As Long: hBmp As Long: hPal As Long: Reserved As Long End Type Private Sub SaveClipToPic() Dim hBitmap As Long, sPath As String, Pic As PicBmp, IPic As IPicture Dim IID_IDispatch As GUID sPath = "C:\Users\hbri\Desktop\ClipBoard\Datei.bmp" If OpenClipboard(0&) Then hBitmap = GetClipboardData(2) ' 2 = CF_BITMAP If hBitmap <> 0 Then With Pic .Size = Len(Pic) .Type = 1 ' Bildtyp .hBmp = hBitmap .hPal = 0 .Reserved = 0 End With With IID_IDispatch .Data1 = &H20400 .Data4(0) = &HC0 .Data4(7) = &H46 End With OleCreatePictureIndirect Pic, IID_IDispatch, True, IPic SavePicture IPic, sPath 'MsgBox "Bild erfolgreich gespeichert unter: " & sPath Else MsgBox "Die Zwischenablage enthält kein Bild." End If CloseClipboard Else MsgBox "Die Zwischenablage konnte nicht geöffnet werden." End If End Sub Private Sub InsertPicAtCursor() Dim oMail As Outlook.MailItem, oInspector As Outlook.Inspector Dim oDoc As Object, oSelection As Object, sPath As String sPath = "C:\Users\hbri\Desktop\ClipBoard\Datei.bmp" Set oMail = Application.ActiveInspector.CurrentItem Set oInspector = oMail.GetInspector Set oDoc = oInspector.WordEditor Set oSelection = oDoc.Application.Selection oSelection.InlineShapes.AddPicture sPath, False, True 'MsgBox "Bild erfolgreich eingefügt!" End Sub Private Sub SetPicSize() Dim oMail As MailItem, oInspector As Inspector Dim oDoc As Object, oShape As Object, dbRation As Double Dim dbWidth As Double, dbHeight As Double Set oMail = Application.ActiveInspector.CurrentItem Set oInspector = Application.ActiveInspector Set oDoc = oInspector.WordEditor Set oShape = oDoc.InlineShapes(oDoc.InlineShapes.Count) dbRation = oShape.Height / oShape.Width dbWidth = 200 dbHeight = dbWidth * dbRation oShape.Width = dbWidth oShape.Height = dbHeight End Sub Sub ClipToMail() SaveClipToPic InsertPicAtCursor SetPicSize End Sub </code></pre></div> Wie schon erwähnt, stehen auch andere Optionen zur Verfügung - wenn sie jemand <em class="text-italics">hier </em>spezifiziert.<br> <br> Viel Spaß damit!</div> <div id='list_thanks2007'> </div> <div id='div_post_reput2007'> </div> <div id="sig2007" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2009" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2009"> <dt class="no-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">knobbi38</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=6135&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">32</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 20. Okt 2024, 14:15</dd> <dd class="profile-posts" data-user-give-id="6135"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/6135/true?sid=18f95990791d43b3ba8ad966ef67ee0a">2 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="6135"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/6135/false?sid=18f95990791d43b3ba8ad966ef67ee0a">26 Mal</a></dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von knobbi38"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von knobbi38</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="./memberlist.php?mode=email&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" title="E-Mail senden" class="last-cell"> <span class="contact-icon email-icon">E-Mail senden</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content2009"> <h3 > <a href="./viewtopic.php?p=2009&sid=18f95990791d43b3ba8ad966ef67ee0a#p2009">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2009/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2009&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2009" title="Kopiert den Beitragslink in die Zwischenablage">#3</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2009&sid=18f95990791d43b3ba8ad966ef67ee0a#p2009" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">knobbi38</a></strong> » </span><time datetime="2025-01-01T22:49:18+00:00">1. Jan 2025, 23:49</time> </p> <div class="content">Hallo d'r Bastler,<br> <br> hier ein paar Anpassungen bei den API Deklarationen: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Public Type GUID Data1 As Long Data2 As Integer Data3 As Integer Data4(0 To 7) As Byte End Type Public Type PICTDESC Size As Long Type As Long hPic As LongPtr hPal As LongPtr End Type Public Declare PtrSafe Function OleCreatePictureIndirect Lib "oleaut32.dll" ( _ ByRef PicDesc As PICTDESC, _ ByRef RefIID As GUID, _ ByVal fPictureOwnsHandle As LongPtr, _ ByRef IPic As IPicture ) As LongPtr Public Declare PtrSafe Function OpenClipboard Lib "user32" _ Alias "OpenClipboard" (ByVal hwnd As LongPtr) As Long Public Declare PtrSafe Function CloseClipboard Lib "user32" _ Alias "CloseClipboard" () As Long Public Declare PtrSafe Function GetClipboardData Lib "user32" _ Alias "GetClipboardDataA" (ByVal wFormat As Long) As LongPtr Public Const CF_BITMAP = 2 ' Das Objekt in der Zwischenablage ist ein ' Handle eines Bitmaps </code></pre></div> Bitte beachte die geänderte Library Angabe bei OleCreatePictureIndirect (). Auch wird die Struktur üblicherweise in der API Doku mit PICTDESC bezeichnet, anstatt mit PicBmp.<br> <br> Gruß<br> Knobbi38</div> <div id='list_thanks2009'> </div> <div id='div_post_reput2009'> </div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2011" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile2011"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=18f95990791d43b3ba8ad966ef67ee0a">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=18f95990791d43b3ba8ad966ef67ee0a">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2011"> <h3 > <a href="./viewtopic.php?p=2011&sid=18f95990791d43b3ba8ad966ef67ee0a#p2011">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2011/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2011&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2011" title="Kopiert den Beitragslink in die Zwischenablage">#4</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2011&sid=18f95990791d43b3ba8ad966ef67ee0a#p2011" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-01-02T11:07:59+00:00">2. Jan 2025, 12:07</time> </p> <div class="content">Moin Knobbi,<br> <br> ganz lieben Dank für Deine Ergänzung!<br> <br> Also habe ich eben mal gebastelt und Deine Änderungen in den vorherigen Code übernommen. Erwartungsgemäß bin ich dann mal gleich <span style="background-color:yellow">gelb </span>markiert hängengeblieben: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>If OpenClipboard(0&) Then hBitmap = GetClipboardData(2) ' 2 = CF_BITMAP If hBitmap <> 0 Then With Pic .Size = Len(Pic) .Type = 1 ' Bildtyp .hPic = hBitmap ''' >>> hBmp = ... .hPal = 0 '.Reserved = 0 ''' >>> End With</code></pre></div> Nach Änderung / Auskommentieren der durch '''>>> markierten Zeilen, hat das dann aber klaglos funktioniert. <br> <br> Was mich neugierig folgende Frage stellen lässt: Es wird weiterhin ein BMP verwendet. Kann man VBA auch dazu bewegen, GIF oder PNG zu verarbeiten? Ich denke da an Transparenz, die beim BMP ja nur für das ganze Bild greift.<br> <br> Schöne Grüße</div> <div id='list_thanks2011'> </div> <div id='div_post_reput2011'> </div> <div id="sig2011" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2012" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2012"> <dt class="no-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">knobbi38</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=6135&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">32</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 20. Okt 2024, 14:15</dd> <dd class="profile-posts" data-user-give-id="6135"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/6135/true?sid=18f95990791d43b3ba8ad966ef67ee0a">2 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="6135"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/6135/false?sid=18f95990791d43b3ba8ad966ef67ee0a">26 Mal</a></dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von knobbi38"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von knobbi38</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="./memberlist.php?mode=email&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" title="E-Mail senden" class="last-cell"> <span class="contact-icon email-icon">E-Mail senden</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content2012"> <h3 > <a href="./viewtopic.php?p=2012&sid=18f95990791d43b3ba8ad966ef67ee0a#p2012">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2012/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2012&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2012" title="Kopiert den Beitragslink in die Zwischenablage">#5</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2012&sid=18f95990791d43b3ba8ad966ef67ee0a#p2012" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">knobbi38</a></strong> » </span><time datetime="2025-01-02T13:17:07+00:00">2. Jan 2025, 14:17</time> </p> <div class="content">Hallo,<br> <br> theoretisch sollte das gehen, aber dann müssen die beteiligten Anwendungen das verwendete Clipboard-Format auch gleich interpretieren, was offensichtlich nicht immer sichergestellt ist. <br> <br> Ich habe <a href="https://newsgroup.xnview.com/viewtopic.php?t=34761" class="postlink">hier</a> einen alten Thread gefunden, wo es auch um so ein Problem in Verbindung mit XnView ging. Um sich den Inhalt des Clipboard anschauen und untersuchen zu können, braucht man dann noch ein Tool wie Clipboard Format Spy oder <a href="https://www.nirsoft.net/utils/inside_clipboard.html" class="postlink">InsideClipboard</a>. <br> <br> Per Automation sollte das einfacher zu lösen sein. Da könnte man auch auf WIA zurück greifen.<br> <br> Gruß<br> Knobbi38</div> <div id='list_thanks2012'> </div> <div id='div_post_reput2012'> </div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2013" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile2013"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=18f95990791d43b3ba8ad966ef67ee0a">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=18f95990791d43b3ba8ad966ef67ee0a">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2013"> <h3 > <a href="./viewtopic.php?p=2013&sid=18f95990791d43b3ba8ad966ef67ee0a#p2013">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2013/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2013&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2013" title="Kopiert den Beitragslink in die Zwischenablage">#6</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2013&sid=18f95990791d43b3ba8ad966ef67ee0a#p2013" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-01-02T13:58:21+00:00">2. Jan 2025, 14:58</time> </p> <div class="content">Danke Knobbi,<br> <br> damit habe ich schon mal meine nächsten Hausaufgaben <img class="smilies" src="./images/smilies/icon_e_wink.gif" width="15" height="17" alt=";-)" title="Wink"><br> <br> Hier als Fortsetzung des Projekts zwei Snippets, die jeweils aus Word oder Excel eine neue Mail in Outlook bauen. Mit Excel kann man Empfänger, Betreff und Inhalt aus einer Tabelle ziehen. Mit Word muss man sie von Hand eintragen oder sich entsprechende Textmarken bauen.<br> <br> Für Word: Den Code in ein Modul und dann zu finden unter Alt+F8<div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Option Explicit Sub OpenMail() Dim oOutlookApp As Object, oMail As Object Set oOutlookApp = CreateObject("Outlook.Application") Set oMail = oOutlookApp.CreateItem(0) With oMail .To = "MailtTo" .Subject = "Subject" .Body = "Body" .Display End With Set oMail = Nothing Set oOutlookApp = Nothing End Sub</code></pre></div> Für Excel: Hier kommt der Code in eine Tabelle und kann per Doppelklick aufgerufen werden<div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True OpenMail Target.Row End Sub Sub OpenMail(iRow As Integer) Dim oOutlookApp As Object, oMail As Object Set oOutlookApp = CreateObject("Outlook.Application") Set oMail = oOutlookApp.CreateItem(0) With oMail .To = Cells(iRow, 1) .Subject = Cells(iRow, 2) .Body = Cells(iRow, 3) .Display End With Set oMail = Nothing Set oOutlookApp = Nothing End Sub</code></pre></div> Viel Spaß damit!</div> <div id='list_thanks2013'> </div> <div id='div_post_reput2013'> </div> <div id="sig2013" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2015" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2015"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=18f95990791d43b3ba8ad966ef67ee0a">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=18f95990791d43b3ba8ad966ef67ee0a">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2015"> <h3 > <a href="./viewtopic.php?p=2015&sid=18f95990791d43b3ba8ad966ef67ee0a#p2015">Re: Grafische Zwischenablage in Mail einfügen ...</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2015/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2015&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2015" title="Kopiert den Beitragslink in die Zwischenablage">#7</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2015&sid=18f95990791d43b3ba8ad966ef67ee0a#p2015" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-01-03T01:01:24+00:00">3. Jan 2025, 02:01</time> </p> <div class="content">Moin allerseits,<br> <br> hier eine Lösung für Word-Dokumente, in denen bitte folgende Textmarken (eine pro Zeile) angelegt werden: <br> <strong class="text-strong">MailTo, Subject</strong> und <strong class="text-strong">Body</strong>, die mit einer beliebigen E-Mail-Adresse und Betreff belegt werden. <br> <br> Für den Body bietet sich folgender Text (ohne manuelle Zeilenumbrüche!) an:<blockquote class="uncited"><div>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</div></blockquote> Dann bekommt <em class="text-italics">ThisDocument</em> diesen neuen Code (ggf. hinzugefügt): <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Option Explicit Sub MailByBookMarks() Dim i As Integer, sText(3) As String, aBookMarks Dim oOutlookApp As Object, oMail As Object aBookMarks = Array("MailTo", "Subject", "Body") For i = 0 To UBound(aBookMarks) Selection.GoTo what:=wdGoToBookmark, Name:=aBookMarks(i) Selection.EndOf Unit:=wdParagraph, Extend:=wdExtend sText(i) = Selection.Text Next i Set oOutlookApp = CreateObject("Outlook.Application") Set oMail = oOutlookApp.CreateItem(0) With oMail .To = sText(0) .Subject = sText(1) .Body = sText(2) & vbCrLf .Display End With Set oMail = Nothing Set oOutlookApp = Nothing End Sub</code></pre></div> Das Makro (sichtbar unter Alt-F8) baut eine neue Mail, in der man seinen Cursor an die gewünschte Position setzt. Und schon kann man mit dem bereits bekannten Makro sein(e) Bild(er) einfügen.<br> <br> Optionale Schatten und andere Format-Spielereien gibt es später als einzelne Makros nach Fertigstellung.<br> <br> Und wieder einen Schritt weiter <img class="smilies" src="./images/smilies/icon_e_wink.gif" width="15" height="17" alt=";)" title="Wink"> Viel Spaß damit!</div> <div id='list_thanks2015'> </div> <div id='div_post_reput2015'> </div> <div id="sig2015" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2017" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile2017"> <dt class="no-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">knobbi38</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=6135&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">32</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 20. Okt 2024, 14:15</dd> <dd class="profile-posts" data-user-give-id="6135"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/6135/true?sid=18f95990791d43b3ba8ad966ef67ee0a">2 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="6135"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/6135/false?sid=18f95990791d43b3ba8ad966ef67ee0a">26 Mal</a></dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von knobbi38"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von knobbi38</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="./memberlist.php?mode=email&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" title="E-Mail senden" class="last-cell"> <span class="contact-icon email-icon">E-Mail senden</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content2017"> <h3 > <a href="./viewtopic.php?p=2017&sid=18f95990791d43b3ba8ad966ef67ee0a#p2017">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2017/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2017&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2017" title="Kopiert den Beitragslink in die Zwischenablage">#8</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2017&sid=18f95990791d43b3ba8ad966ef67ee0a#p2017" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=6135&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">knobbi38</a></strong> » </span><time datetime="2025-01-04T00:01:46+00:00">4. Jan 2025, 01:01</time> </p> <div class="content">Hallo,<br> <br> warum so umständlich mit Textmarken? Eine 3-spaltige Tabelle reicht doch vollkommen und lässt sich noch einfacher ansprechen.<br> Anbei eine kleine Hilfsfunktion zum Auslesen eines Zellinhaltes.<br> <br> Gruß <br> Knobbi38</div> <div class="rules">Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.</div> <div id='list_thanks2017'> </div> <div id='div_post_reput2017'> </div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2018" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2018"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=18f95990791d43b3ba8ad966ef67ee0a">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=18f95990791d43b3ba8ad966ef67ee0a">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2018"> <h3 > <a href="./viewtopic.php?p=2018&sid=18f95990791d43b3ba8ad966ef67ee0a#p2018">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2018/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2018&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2018" title="Kopiert den Beitragslink in die Zwischenablage">#9</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2018&sid=18f95990791d43b3ba8ad966ef67ee0a#p2018" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-01-04T12:05:56+00:00">4. Jan 2025, 13:05</time> </p> <div class="content">Moin Knobbi,<br> <br> dass Du es ausgerechnet beim Thema Clipboard so kompliziert machst und einen 6-Zeiler als Anhang hoch lädst ... <img class="smilies" src="./images/smilies/icon_mrgreen.gif" width="15" height="17" alt=":mrgreen:" title="Mr. Green"> Aber natürlich danke für den wirklich bequemen Weg. In Excel ist die Adressierung der Zellen natürlich noch einfacher. Da kann man gleich ganze Reihen von Zellen aus Textbausteinen in eine Mail schicken. Ideal für Service-Hotlines, die die Wünsche ihrer Kunden <em class="text-italics">herzlich ernst nehmen</em> ... <img class="smilies" src="./images/smilies/icon_evil.gif" width="15" height="17" alt=":evil:" title="Evil or Very Mad"> <br> <br> Jetzt aber für Karthagos (herzlich willkommen übrigens!) noch die Sache mit dem Schatten um eingefügte Clips. Das Snippet (Code ins Modul, Aufruf über Alt-F8) umrahmt alle Bilder einer Mail: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Sub ShadowPics() Dim oMail As MailItem, oInspector As Inspector Dim oDoc As Object, oShape As Object, iShp As Integer Set oMail = Application.ActiveInspector.CurrentItem Set oInspector = Application.ActiveInspector Set oDoc = oInspector.WordEditor iShp = 1 For Each oShape In oDoc.InlineShapes Set oShape = oDoc.InlineShapes(iShp) With oShape With .Shadow .Visible = msoTrue .OffsetX = 0 .OffsetY = 0 .Transparency = 0.5 .Blur = 10 .ForeColor.RGB = RGB(0, 0, 0) End With End With iShp = iShp + 1 Next End Sub</code></pre></div> Weitere Formatierungen gerne auf Anfrage.<br> <br> Viel Spaß damit!</div> <div id='list_thanks2018'> </div> <div id='div_post_reput2018'> </div> <div id="sig2018" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2034" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile2034"> <dt class="no-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=6137&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">Karthagos</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=6137&sr=posts&sid=18f95990791d43b3ba8ad966ef67ee0a">1</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 2. Jan 2025, 14:45</dd> <dd class="profile-posts" data-user-give-id="6137"></dd> <dd class="profile-posts" data-user-receive-id="6137"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/6137/false?sid=18f95990791d43b3ba8ad966ef67ee0a">1 Mal</a></dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von Karthagos"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von Karthagos</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="./memberlist.php?mode=email&u=6137&sid=18f95990791d43b3ba8ad966ef67ee0a" title="E-Mail senden" class="last-cell"> <span class="contact-icon email-icon">E-Mail senden</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content2034"> <h3 > <a href="./viewtopic.php?p=2034&sid=18f95990791d43b3ba8ad966ef67ee0a#p2034">Re: Grafische Zwischenablage in Mail einfügen >step 1<</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2034/report?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2034&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2034" title="Kopiert den Beitragslink in die Zwischenablage">#10</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2034&sid=18f95990791d43b3ba8ad966ef67ee0a#p2034" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=6137&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">Karthagos</a></strong> » </span><time datetime="2025-01-08T07:28:14+00:00">8. Jan 2025, 08:28</time> </p> <div class="content">Hallo d'rBastler, danke für Deine Mitteilung und die Fertigstellung des Schattenmakros für alle Bilder.<br> Hut ab, was Du da geleistet hast, funktioniert einwandfrei, nochmals vielen Dank.<br> <br> Schade, dass es im Office-Forum mit EarlFred so einen Disput gab, war völlig unnötig, gehört aber anscheinend in unserer Internetwelt inzwischen dazu.<br> <br> Viele Grüße und einen guten Jahresstart<br> Günther</div> <div id='list_thanks2034'> <div class="notice"> <dl> <dt>Folgende Benutzer bedankten sich beim Autor <a href="./memberlist.php?mode=viewprofile&u=6137&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">Karthagos</a> für den Beitrag: </dt> <dd> <span title="8. Jan 2025, 19:25"><a href="./memberlist.php?mode=viewprofile&u=58&sid=18f95990791d43b3ba8ad966ef67ee0a" class="username">d'r Bastler</a></span> </dd> </dl> </div> </div> <div id='div_post_reput2034'> </div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div class="action-bar bar-bottom"> <a href="./posting.php?mode=reply&t=664&sid=18f95990791d43b3ba8ad966ef67ee0a" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./memberlist.php?mode=email&t=664&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Thema weiterempfehlen"> <i class="icon fa-envelope-o fa-fw" aria-hidden="true"></i><span>Thema weiterempfehlen</span> </a> </li> <li> <a href="./viewtopic.php?t=664&sid=18f95990791d43b3ba8ad966ef67ee0a&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <form method="post" action="./viewtopic.php?t=664&sid=18f95990791d43b3ba8ad966ef67ee0a"> <div class="dropdown-container dropdown-container-left dropdown-button-control sort-tools"> <span title="Anzeige- und Sortierungs-Einstellungen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-sort-amount-asc fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown hidden"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents"> <fieldset class="display-options"> <label>Anzeigen: <select name="st" id="st"><option value="0" selected="selected">Alle Beiträge</option><option value="1">1 Tag</option><option value="7">7 Tage</option><option value="14">2 Wochen</option><option value="30">1 Monat</option><option value="90">3 Monate</option><option value="180">6 Monate</option><option value="365">1 Jahr</option></select></label> <label>Sortiere nach: <select name="sk" id="sk"><option value="a">Autor</option><option value="t" selected="selected">Erstellungsdatum</option><option value="s">Betreff</option></select></label> <label>Richtung: <select name="sd" id="sd"><option value="a" selected="selected">Aufsteigend</option><option value="d">Absteigend</option></select></label> <hr class="dashed" /> <input type="submit" class="button2" name="sort" value="Los" /> </fieldset> </div> </div> </div> </form> <div class="pagination"> 10 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div class="action-bar actions-jump"> <p class="jumpbox-return"> <a href="./viewforum.php?f=5&sid=18f95990791d43b3ba8ad966ef67ee0a" class="left-box arrow-left" accesskey="r"> <i class="icon fa-angle-left fa-fw icon-black" aria-hidden="true"></i><span>Zurück zu „Microsoft Outlook“</span> </a> </p> <div class="jumpbox dropdown-container dropdown-container-right dropdown-up dropdown-left dropdown-button-control" id="jumpbox"> <span title="Gehe zu" class="button button-secondary dropdown-trigger dropdown-select"> <span>Gehe zu</span> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li><a href="./viewforum.php?f=1&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> VBAsteleien.de - Herzlich willkommen!</span></a></li> <li><a href="./viewforum.php?f=8&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Microsoft Access</span></a></li> <li><a href="./viewforum.php?f=3&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Microsoft Excel</span></a></li> <li><a href="./viewforum.php?f=9&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Tutorials</span></a></li> <li><a href="./viewforum.php?f=5&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Microsoft Outlook</span></a></li> <li><a href="./viewforum.php?f=10&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Microsoft Powerpoint</span></a></li> <li><a href="./viewforum.php?f=7&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Microsoft Visio</span></a></li> <li><a href="./viewforum.php?f=11&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Microsoft Word</span></a></li> <li><a href="./viewforum.php?f=6&sid=18f95990791d43b3ba8ad966ef67ee0a" class="jumpbox-forum-link"> <span> Off Topic</span></a></li> </ul> </div> </div> </div> <div class="stat-block online-list"> <h3><a href="./viewonline.php?sid=18f95990791d43b3ba8ad966ef67ee0a">Wer ist online?</a></h3> <p>Mitglieder in diesem Forum: 0 Mitglieder und 0 Gäste</p> </div> </div> <div id="page-footer" class="page-footer" role="contentinfo"> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-footer" class="nav-footer linklist" role="menubar"> <li class="breadcrumbs"> <span class="crumb"><a href="https://VBAsteleien.de" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span>Startseite</span></a></span> <span class="crumb"><a href="./index.php?sid=18f95990791d43b3ba8ad966ef67ee0a" data-navbar-reference="index"><span>VBAsteleien.de -Foren-Übersicht-</span></a></span> </li> <li class="rightside">Alle Zeiten sind <span title="Europa/Berlin">UTC+01:00</span></li> <li class="rightside"> <a href="./ucp.php?mode=delete_cookies&sid=18f95990791d43b3ba8ad966ef67ee0a" data-ajax="true" data-refresh="true" role="menuitem"> <i class="icon fa-trash fa-fw" aria-hidden="true"></i><span>Alle Cookies löschen</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./memberlist.php?sid=18f95990791d43b3ba8ad966ef67ee0a" title="Zeigt eine vollständige Liste aller Mitglieder an" role="menuitem"> <i class="icon fa-group fa-fw" aria-hidden="true"></i><span>Mitglieder</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./memberlist.php?mode=team&sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="rightside" data-last-responsive="true"><a href="/app.php/aboutus?sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"><i class="icon fa-info-circle fa-fw" aria-hidden="true"></i><span>Impressum</span></a></li> <li class="rightside" data-last-responsive="true"> <a href="./memberlist.php?mode=contactadmin&sid=18f95990791d43b3ba8ad966ef67ee0a" role="menuitem"> <i class="icon fa-envelope fa-fw" aria-hidden="true"></i><span>Kontakt</span> </a> </li> </ul> </div> </div> <div class="copyright"> <p class="footer-row"> <span class="footer-copyright">Powered by <a href="https://www.phpbb.com/">phpBB</a>® Forum Software © phpBB Limited</span> </p> <p class="footer-row"> <span class="footer-copyright">Deutsche Übersetzung durch <a href="https://www.phpbb.de/">phpBB.de</a></span> </p> <p class="footer-row" role="menu"> <a class="footer-link" href="./ucp.php?mode=privacy&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Datenschutz" role="menuitem"> <span class="footer-link-text">Datenschutz</span> </a> | <a class="footer-link" href="./ucp.php?mode=terms&sid=18f95990791d43b3ba8ad966ef67ee0a" title="Nutzungsbedingungen" role="menuitem"> <span class="footer-link-text">Nutzungsbedingungen</span> </a> </p> </div> <div id="darkenwrapper" class="darkenwrapper" data-ajax-error-title="AJAX-Fehler" data-ajax-error-text="Bei der Verarbeitung deiner Anfrage ist ein Fehler aufgetreten." data-ajax-error-text-abort="Der Benutzer hat die Anfrage abgebrochen." data-ajax-error-text-timeout="Bei deiner Anfrage ist eine Zeitüberschreitung aufgetreten. Bitte versuche es erneut." data-ajax-error-text-parsererror="Bei deiner Anfrage ist etwas falsch gelaufen und der Server hat eine ungültige Antwort zurückgegeben."> <div id="darken" class="darken"> </div> </div> <div id="phpbb_alert" class="phpbb_alert" data-l-err="Fehler" data-l-timeout-processing-req="Bei der Anfrage ist eine Zeitüberschreitung aufgetreten."> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <h3 class="alert_title"> </h3><p class="alert_text"></p> </div> <div id="phpbb_confirm" class="phpbb_alert"> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <div class="alert_text"></div> </div> </div> </div> <div> <a id="bottom" class="anchor" accesskey="z"></a> <img class="sr-only" aria-hidden="true" src="/app.php/cron/cron.task.text_reparser.poll_option?sid=18f95990791d43b3ba8ad966ef67ee0a" width="1" height="1" alt=""> </div> <script src="./assets/javascript/jquery-3.6.0.min.js?assets_version=53"></script> <script src="./assets/javascript/core.js?assets_version=53"></script> <script src="./ext/kasimi/postnumbers/styles/all/template/postnumbers.js?assets_version=53"></script> <script src="./styles/prosilver/template/forum_fn.js?assets_version=53"></script> <script src="./styles/prosilver/template/ajax.js?assets_version=53"></script> <script src="./ext/vse/abbc3/styles/all/template/js/abbc3.min.js?assets_version=53"></script> <script> var postNumbers = { lang: { copied : 'Kopiert\u0021', copyManually : 'Beitragslink\u0020in\u0020die\u0020Zwischenablage\u003A\u0020Ctrl\/Cmd\u002BC,\u0020Enter' } }; </script> </body> </html>

CINXE.COM

Grafische Zwischenablage in Mail einfügen -