Drag an Outlook email into Excel

Solved
Tobar4 Posted messages 284 Registration date   Status Membre Last intervention   -  
 Babylou -
Hello,

I am currently working on an Excel form.
I would like users to be able to drag an email from Outlook to Excel, as is perfectly feasible with Word.
In this case, Excel shows me the email's subject, sender, and date, but the email itself is not in the file.

PS: This form should not contain any VBA so that I won't have to modify all user workstations (too many)

Thank you for your help.
Charles.
Configuration: Windows XP Internet Explorer 7.0

1 réponse

tchaning Posted messages 4629 Status Membre 299
 
Copy the email to the desktop, open Excel

Insert ==> Object ==> Create from file ==> then select the file ==> OK.

The email icon will then appear :)
--
Don't forget to mark your posts as Resolved if that's the case.
Thank you
42
Frany
 
Thank you ++
0
soniaH
 
SUPER, thank you :)
0
Babylou
 
Works, simple and effective, thanks!!
0