Wait; I figured out how to get the data into Word.
My questions are now much less. How can I make certain lines show up in red? Google has been less helpful here. I'd also like to automatically set the margins and use drop-down boxes for items where there are only 2-4 choices. For others I'd...
Okay, hopefully this pops the thread back up to the top?
The above script works fantastic for what I *thought* I needed, but now apparently we need to attach a certain Word file to the email.
I've figured out how to get it to open a new Word document, but how can I dynamically insert content...
That's pretty slick. For some reason it won't let me add multiple attachments but I can work around that since that'd be uncommon.
Any comments?
' ############################################## Begin script ##########################################################
'
' ***** Open new message...
SWEET. That worked great. Any idea how I can have it default to a different directory than "My Documents?"
(Believe it or not I *am* searching old posts while I do this.)
Why not use a batchfile that includes the "net use" command? I have one of those that runs at logon and maps 5 network drives and also 8 network printers. Makes life super easy.
Awesome! That worked beautifully.
I'd also like to have it automatically open the "File open" dialogue so I can attach a report (whose name will vary unpredictably based on not only the date but also the type of activity involved so unfortunately I can't have it add automatically.)
I searched...
Hi guys. I am both (a) new here and (b) new to VB altogether so I apologize if this seems like a stupid question.
In my office we have an email we send several times per day to numerous recipients with just minor variations. Once upon a time we had a .vbs (written by an old employee) that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.