Is there a way using VBA code, for all outgoing emails to - Get the file path
for the attachment and insert it in the body before it is send out? Kind of a
combination or automation of insert link and insert attachment, using one
click

Thanks,

Irene

An attachment has no file path, unless you inserted it as a link. And in that case, what's the point of having both the text and the link?
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Irene" wrote in message ...
Is there a way using VBA code, for all outgoing emails to - Get the file path
for the attachment and insert it in the body before it is send out? Kind of a
combination or automation of insert link and insert attachment, using one
click

Thanks,

Irene

You could use Attachment.FileName and .PathName to try to get to the
original attachment file and then read it as a text stream and insert that
into the email. Of course you'd have to distinguish attached Outlook items,
pictures and so on from true files. Also, some files don't make sense when
read as pure bytes, for example Word document files or Excel XLS files.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Irene" wrote in message
...
Is there a way using VBA code, for all outgoing emails to - Get the file
path
for the attachment and insert it in the body before it is send out? Kind
of a
combination or automation of insert link and insert attachment, using one
click

Thanks,

Irene

aha, that is what I noticed. I know it sounds point less, but the client is
always right . Is there away to automate the hyperlink dilog box to always
open up to the same place? I guess i am just going to let them now.

Thanks for the help

"Sue Mosher [MVP-Outlook]" wrote:

An attachment has no file path, unless you inserted it as a link. And in that case, what's the point of having both the text and the link?
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Irene" wrote in message ...
Is there a way using VBA code, for all outgoing emails to - Get the file path
for the attachment and insert it in the body before it is send out? Kind of a
combination or automation of insert link and insert attachment, using one
click

Thanks,

Irene

No, you can't automate the dialog used to insert the hyperlink.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Irene" wrote in message ...
aha, that is what I noticed. I know it sounds point less, but the client is
always right . Is there away to automate the hyperlink dilog box to always
open up to the same place? I guess i am just going to let them now.

Thanks for the help

"Sue Mosher [MVP-Outlook]" wrote:

An attachment has no file path, unless you inserted it as a link. And in that case, what's the point of having both the text and the link?


"Irene" wrote in message ...
Is there a way using VBA code, for all outgoing emails to - Get the file path
for the attachment and insert it in the body before it is send out? Kind of a
combination or automation of insert link and insert attachment, using one
click

Thanks,

Irene