We help IT Professionals succeed at work.

Attaching Links in OUTLOOK VBA

ronprowse
ronprowse asked
on
Medium Priority
501 Views
Last Modified: 2009-07-29
I know how to attach a link instead of a file to an email attachment but i need to bring up a file dialog windows so that the user can navigate to the required file. I can do this in Excel using 'application.GetOpenFilename(All files (*.*),*.*")' How do i do this within outlook
Comment
Watch Question

I'm not sure that I fully understand your question...

You want to include a link in an email, and when the user clicks that link they will be displayed a "File Open" style dialog box?

If your user's already have the VB runtime files installed you could have a link to an exe that will display the dialog box and perform the necesary processing.

Something like:

\\myserver\myfolder\fileopen.exe folder=D:\SomeFiles Filter=All files (*.*),*.*
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
You could create a commondialog with API/code only in a module:

http://www.vbcode.com/asp/showsn.asp?theID=373
http://www.vbaccelerator.com/codelib/cmdlgd/cmdlgd.htm
Hope it helps
CERTIFIED EXPERT
Author of the Year 2009

Commented:
Hi ronprowse,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Save as PAQ -- No Refund.
    *** I think the question is too ambiguous to select a winner here.

ronprowse, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
Without additional clarification from ronprowse, I don't think we can really answer this question.
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.