Re: Calling Outlook from within Excel

From: Sue Mosher [MVP-Outlook] (suemvp_at_outlookcode.com)
Date: 02/12/05 

Date: Sat, 12 Feb 2005 08:46:25 -0500

Sure:

    objMail.Attachments.Add yourvariable_with_the_path 

-- 
Sue Mosher, Outlook MVP
Author of
     Microsoft Outlook Programming - Jumpstart for
     Administrators, Power Users, and Developers
     http://www.outlookcode.com/jumpstart.aspx
"Hogan's Goat" <yeah@right.com> wrote in message 
news:Xns95FAEE1149C3Byeah.right.com@63.223.5.246...
> Here's a cheerful little earful from Sue Mosher [MVP-Outlook]:
>
>> Outlook cannot attach files until they're saved. Your code will need
>> to save the active workbook first, then attach it.
>>
>
> OK, fair enough.  My code can save the file and I guess capture the path
> and put it into a variable, then can I use that variable within the same
> code to pass to Outlook as an attachment path?
>

Relevant Pages

  • Re: problems with contacts
    ... Sue Mosher, Outlook MVP ... >> folder when you first access the Contacts navigation pane. ... the physically first on the list. ...
    (microsoft.public.outlook)
  • Re: Setting Company Wide Signature
    ... My point is that you can't prevent a user from simply deleting signature ... Sue Mosher, Outlook MVP ... > side products but I think server side is certainly better in terms of ease ... >>>>> Sue Mosher, Outlook MVP ...
    (microsoft.public.outlook.installation)
  • Re: How to clean the Outlook forms cache in outlook 2002?
    ... Sue Mosher, Outlook MVP ... > Set myItem = myItems.Add ... >>> Dim objFolder ...
    (microsoft.public.office.developer.outlook.forms)
  • Re: help with AddRecipToContacts procedure by Sue Mosher
    ... Sue Mosher, Outlook MVP ... I am using the code by Sue Mosher that's found here ... recipients of my outgoing mail to my contacts folder. ... Exchange user, I end up with a contact that has an email address like this: ...
    (microsoft.public.outlook.program_vba)
  • Re: Error publishing to Organizational Forms Library
    ... > Sue Mosher, Outlook MVP ... >> When eveythings coming at you at once, you're in the wrong lane. ... >>> Sue Mosher, Outlook MVP ...
    (microsoft.public.outlook.program_vba)