Logo GNT
Actualités Tests & Guides Bons Plans
Twitter iPhone pliant OnePlus 11 PS5 Disney+ Orange Livebox Windows 11
Entraide Applications Microsoft Office Excel outlook express et vba excel

outlook express et vba excel

2 réponses
Avatar
STEPH B
Bonjour,
¨
Je suis à la recherche d'une procédure qui lorsque je click sur un bouton
excel il me supprime tous les emails dans la boites de réception de OUTLOOK
EXPRESS.

est ce possible?

merci
Signaler un problème avec ce contenu

2 réponses

Supprimer
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire

Veuillez sélectionner un problème

Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Avatar
isabelle
bonjour Steph,

ce n'est possible car OE ne gere pas l'automation comme le fait Outlook, :-(

isabelle



Le 2010-02-24 11:49, STEPH B a écrit :
Bonjour,
¨
Je suis à la recherche d'une procédure qui lorsque je click sur un bouton
excel il me supprime tous les emails dans la boites de réception de OUTLOOK
EXPRESS.

est ce possible?

merci





Avatar
michdenis
Ce message est composé et au format MIME.

------=_NextPart_000_002B_01CAB5A4.25E81070
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Bonjour,

Sur ton disque dur, recherche les fichiers ayant une extension ".dbx"
lorsque tu auras trouvé le répertoire, pour supprimer tous les fichiers
de ce répertoire, tu peux utiliser ce type de macro :

'Attention, cette procédure supprime totalement
'les fichiers sans possibilité de les restaurer.
'-----------------------------------------
Sub test()
Dim Chemin As string, Fichier as String
'où sont ces fichiers :
"c:CheminTrouvé"
Fichier =dir(chemin & "*.dbx")

do while fichier <>""
Kill chemin & fichier
fichier = dir()
Loop

End Sub
'-----------------------------------------

Information supplémentaire :

'**********************************
.dbx files are used by Microsoft's Outlook express email application and contain your email messages.

Outlook Express saves your .dbx in a folder on your computer. To find this folder, open outlook express and select the maintenance option (tools > options > maintenance).
In this folder, you may find a number of .dbx files. Outlook Express creates a .dbx file for each message folder in Outlook Express. So inbox.dbx will contain emails from your inbox for example.

You'll also notice a file called folders.dbx. This file contains an index of all your message folders (and newsgroups) in Outlook express.

It is very difficult to extract individual emails from a .dbx file, however there are many applications available that are able to do this (see DBXtract link below).

Outlook Express comes bundled with most versions of the Windows operating system and is used to compose and view emails. Outlook express is probably the most common email client on the Windows platform. If you have the Microsoft Office suite, a more advanced version of Outlook Express, called Outlook is available which includes additional features such as a calendar.
'**********************************


------=_NextPart_000_002B_01CAB5A4.25E81070
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16490"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV>Bonjour,<BR></DIV>
<DIV><FONT color=#be71c5 size=4>Sur ton disque dur, recherche les fichiers ayant
une extension ".dbx"</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>lorsque tu auras trouvé le répertoire, pour
supprimer tous les fichiers</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>de ce répertoire, tu peux utiliser ce type de
macro :</FONT></DIV>
<DIV><FONT color=#be71c5 size=4></FONT>&nbsp;</DIV>
<DIV><FONT color=#be71c5 size=4>'Attention, cette procédure supprime
totalement</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>'les fichiers sans possibilité de les
restaurer.</FONT></DIV>
<DIV><FONT color=#be71c5
size=4>'-----------------------------------------</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>Sub test()</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>Dim Chemin As string, Fichier as
String</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>'où sont ces fichiers :</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>"c:CheminTrouvé"</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>Fichier =dir(chemin &amp; "*.dbx")</FONT></DIV>
<DIV><FONT color=#be71c5 size=4></FONT>&nbsp;</DIV>
<DIV><FONT color=#be71c5 size=4>do while fichier &lt;&gt;""</FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;<FONT color=#be71c5 size=4>Kill chemin &amp;
fichier</FONT></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;<FONT color=#be71c5 size=4>fichier =
dir()</FONT></DIV>
<DIV><FONT color=#be71c5 size=4>Loop</FONT></DIV>
<DIV><FONT color=#be71c5 size=4></FONT>&nbsp;</DIV>
<DIV><FONT color=#be71c5 size=4>End Sub</FONT></DIV>
<DIV><FONT color=#be71c5
size=4>'-----------------------------------------</FONT></DIV>
<DIV><FONT color=#be71c5 size=4></FONT>&nbsp;</DIV>
<DIV><FONT color=#be71c5 size=4>Information supplémentaire :</FONT></DIV>
<DIV><FONT color=#be71c5 size=4></FONT>&nbsp;</DIV>
<DIV><FONT color=#be71c5 size=4>'**********************************</FONT></DIV>
<DIV>.dbx files are used by Microsoft's Outlook express email application and
contain your email messages.<BR><BR>Outlook Express saves your .dbx in a folder
on your computer. To find this folder, open outlook express and select the
maintenance option (tools &gt; options &gt; maintenance).<BR>In this folder, you
may find a number of .dbx files. Outlook Express creates a .dbx file for each
message folder in Outlook Express. So inbox.dbx will contain emails from your
inbox for example.<BR><BR>You'll also notice a file called folders.dbx. This
file contains an index of all your message folders (and newsgroups) in Outlook
express.<BR><BR>It is very difficult to extract individual emails from a .dbx
file, however there are many applications available that are able to do this
(see DBXtract link below).<BR><BR>Outlook Express comes bundled with most
versions of the Windows operating system and is used to compose and view emails.
Outlook express is probably the most common email client on the Windows
platform. If you have the Microsoft Office suite, a more advanced version of
Outlook Express, called Outlook is available which includes additional features
such as a calendar.</DIV>
<DIV><FONT color=#be71c5
size=4>'**********************************</FONT><BR><BR></DIV></BODY>< /HTML>

------=_NextPart_000_002B_01CAB5A4.25E81070--