2008-04-24, 04:00 #1
- 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.
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!
+ 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!
2008-04-24, 04:10 #2
- 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.