Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automating Word 2000 e-mails
Hi, I'm new to this forum.
I understand some Access VBA and have used it to manipulate and create Word Docs and insert variables derived from my Access 2000 database at bookmarks in a Word Doc. I wanted to use this same kind of method as : oDoc.Bookmarks(sBkMk).Select oApp.Selection.Text = sText to insert an e-mail address in the address line and a subject in the subject line that you get when you have an open Word Doc and you click the e-mail icon on the toolbar. I tried recording a macro running through the keystrokes because I usually have found that doing this then gives you the VBA code that you can adapt for your own use. All I got was: ActiveWindow.EnvelopeVisible = Not ActiveWindow.EnvelopeVisible which meant nothing at all to me. I expected to see the e-mail address and the text that I had put in for the subject matter somewhere in the VBA code and I could then substitute a couple of string variables containing that information - no such luck! Does anyone know how to do this? -- Richard Webster |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automating Word 2000 e-mails
I'd have a look at
http://word.mvps.org/FAQs/InterDev/SendMail.htm Peter Jamieson "Richard Webster" wrote in message ... Hi, I'm new to this forum. I understand some Access VBA and have used it to manipulate and create Word Docs and insert variables derived from my Access 2000 database at bookmarks in a Word Doc. I wanted to use this same kind of method as : oDoc.Bookmarks(sBkMk).Select oApp.Selection.Text = sText to insert an e-mail address in the address line and a subject in the subject line that you get when you have an open Word Doc and you click the e-mail icon on the toolbar. I tried recording a macro running through the keystrokes because I usually have found that doing this then gives you the VBA code that you can adapt for your own use. All I got was: ActiveWindow.EnvelopeVisible = Not ActiveWindow.EnvelopeVisible which meant nothing at all to me. I expected to see the e-mail address and the text that I had put in for the subject matter somewhere in the VBA code and I could then substitute a couple of string variables containing that information - no such luck! Does anyone know how to do this? -- Richard Webster |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automating Word 2000 e-mails
Thanks, that's given me something to work on. The RoutingSlip object didn't
come up at all when I searched help in Word VBA for e-mail! -- Richard Webster "Peter Jamieson" wrote: I'd have a look at http://word.mvps.org/FAQs/InterDev/SendMail.htm Peter Jamieson "Richard Webster" wrote in message ... Hi, I'm new to this forum. I understand some Access VBA and have used it to manipulate and create Word Docs and insert variables derived from my Access 2000 database at bookmarks in a Word Doc. I wanted to use this same kind of method as : oDoc.Bookmarks(sBkMk).Select oApp.Selection.Text = sText to insert an e-mail address in the address line and a subject in the subject line that you get when you have an open Word Doc and you click the e-mail icon on the toolbar. I tried recording a macro running through the keystrokes because I usually have found that doing this then gives you the VBA code that you can adapt for your own use. All I got was: ActiveWindow.EnvelopeVisible = Not ActiveWindow.EnvelopeVisible which meant nothing at all to me. I expected to see the e-mail address and the text that I had put in for the subject matter somewhere in the VBA code and I could then substitute a couple of string variables containing that information - no such luck! Does anyone know how to do this? -- Richard Webster |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Compare Word to Wordperfect? | Microsoft Word Help | |||
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help |