Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2008
    Thanked 0 Times in 0 Posts

    Email a Word Doc with VBA and Lotus Notes (2002)

    I would like to insert a command button that when selected by the EU sends the Word document to an designated email addresss. The mail is on Lotus Notes. v6.x I have done a little bit of VBA in Excel and Access but never in Word. I can figure out how to make the command button, but really need some code for the execution. I have been all over the internet and can't really find anything that is clear.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 93 Times in 89 Posts

    Re: Email a Word Doc with VBA and Lotus Notes (200

    You'll find many examples here of automating Outlook, but those are probably not applicable. This Google search turns up a number of articles on automating Lotus Notes: automate "lotus notes" (vba OR "visual basic").

    For example, in this page, there is a procedure that you might be able to use. From the Word side, you need to feed it the file name (ActiveDocument.FullPath). I wonder whether you need to close the document in order for Lotus Notes to be able to attach it? Hmmm... this is something I can't test myself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts