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.
Subscribe to our Windows Secrets Newsletter - It's Free!
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.