Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   vba code that insert a hyperlink file in the body of message (http://www.outlookbanter.com/outlook-vba/12495-vba-code-insert-hyperlink-file.html)

gabriel April 23rd 06 07:29 PM

vba code that insert a hyperlink file in the body of message
 
Hello,

I'm searching VBA code that insert a file://mypath\mydata.doc in my mail
after he asks me where to find the file (openbox file ?). Is that possible
? I have no particular VBA skills, so...

The macro of my dreams :
1) I'm in the body of the message
2) i clic on a macro button
3) A openbox appear and let me choose the file (that is on my intranet under
\\gab\datat\...)
4) the maco insert the hyperlink file in the body of my message

Have someone an idea ?
thanks
Gabriel



Michael Bauer April 24th 06 06:32 AM

vba code that insert a hyperlink file in the body of message
 
Am Sun, 23 Apr 2006 20:29:00 +0200 schrieb gabriel:

Unfortunately in Outlook there´s no control for selecting a file. Here´s a
sample that uses the Win32 APIs directy:
http://www.mvps.org/access/api/api0001.htm

If you want to add the url at the current cursor position then you need to
use Word as e-mail editor or the Redemption from www.dimatr.com.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Hello,

I'm searching VBA code that insert a file://mypath\mydata.doc in my mail
after he asks me where to find the file (openbox file ?). Is that

possible
? I have no particular VBA skills, so...

The macro of my dreams :
1) I'm in the body of the message
2) i clic on a macro button
3) A openbox appear and let me choose the file (that is on my intranet

under
\\gab\datat\...)
4) the maco insert the hyperlink file in the body of my message

Have someone an idea ?
thanks
Gabriel


gabriel April 24th 06 12:04 PM

vba code that insert a hyperlink file in the body of message
 
is specific for access
does not fit, have vba error (hwnd = Application.hWndAccessApp)
....
mfg
Gabriel

"Michael Bauer" a écrit dans le message de news:
...
Am Sun, 23 Apr 2006 20:29:00 +0200 schrieb gabriel:

Unfortunately in Outlook there´s no control for selecting a file. Here´s a
sample that uses the Win32 APIs directy:
http://www.mvps.org/access/api/api0001.htm

If you want to add the url at the current cursor position then you need to
use Word as e-mail editor or the Redemption from www.dimatr.com.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Hello,

I'm searching VBA code that insert a file://mypath\mydata.doc in my mail
after he asks me where to find the file (openbox file ?). Is that

possible
? I have no particular VBA skills, so...

The macro of my dreams :
1) I'm in the body of the message
2) i clic on a macro button
3) A openbox appear and let me choose the file (that is on my intranet

under
\\gab\datat\...)
4) the maco insert the hyperlink file in the body of my message

Have someone an idea ?
thanks
Gabriel




Michael Bauer April 24th 06 01:51 PM

vba code that insert a hyperlink file in the body of message
 
Am Mon, 24 Apr 2006 13:04:03 +0200 schrieb gabriel:

I suppose you can comment out that line.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


is specific for access
does not fit, have vba error (hwnd = Application.hWndAccessApp)
...
mfg
Gabriel

"Michael Bauer" a écrit dans le message de news:
...
Am Sun, 23 Apr 2006 20:29:00 +0200 schrieb gabriel:

Unfortunately in Outlook there´s no control for selecting a file. Here´s

a
sample that uses the Win32 APIs directy:
http://www.mvps.org/access/api/api0001.htm

If you want to add the url at the current cursor position then you need

to
use Word as e-mail editor or the Redemption from www.dimatr.com.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Hello,

I'm searching VBA code that insert a file://mypath\mydata.doc in my mail
after he asks me where to find the file (openbox file ?). Is that

possible
? I have no particular VBA skills, so...

The macro of my dreams :
1) I'm in the body of the message
2) i clic on a macro button
3) A openbox appear and let me choose the file (that is on my intranet

under
\\gab\datat\...)
4) the maco insert the hyperlink file in the body of my message

Have someone an idea ?
thanks
Gabriel



All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com