A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , , , ,

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





 
 
Thread Tools Display Modes
  #1  
Old April 23rd 06, 07:29 PM posted to microsoft.public.outlook.program_vba
gabriel
external usenet poster
 
Posts: 2
Default 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


Ads
  #2  
Old April 24th 06, 06:32 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default 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

  #3  
Old April 24th 06, 12:04 PM posted to microsoft.public.outlook.program_vba
gabriel
external usenet poster
 
Posts: 2
Default 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



  #4  
Old April 24th 06, 01:51 PM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run VBA Code from 'new mail message' on standard toolbar Carmi Outlook and VBA 8 March 31st 06 05:53 PM
Using VBA code to move current message to a folder Dean Outlook and VBA 4 February 26th 06 01:46 AM
Insert file paths for attachments into message on send. architimmy@gmail.com Outlook and VBA 1 February 17th 06 11:08 PM
Insert a hyperlink to section of Word doc in an outlook message nomad_grrl@yahoo.com Outlook - General Queries 0 February 8th 06 05:07 AM
Can I use VBA to activate a hyperlink in Outlook? businesscentre21-groups@yahoo.com.au Outlook and VBA 2 January 18th 06 12:57 AM


All times are GMT +1. The time now is 02:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Credit Cards - Mortgages - MySpace Backgrounds - Bad Credit Mortgages - Remortgages