Search results for query: *

Hi, My routine creates a new workbook from a template that contains links but I don't want to update the Links yet. So I use the line Workbooks.Add templateStr This works fine but every time it runs asks if I want to update the Links. Is it possible to amend the line so that it does not...

Some time ago I installed Messenger with a @MSN.com passport, I only want to use it for chat, voice, and web cam but not email. Now I have just created a logon for my wife and she wants the same but the install wants me to create a hotmail account. Can’t this be done anymore?

So when do I use Private ?

Thanks John, So if I put the Dim after the start of the Sub routine then it will only be available in that Sub routine, if I put it before the start of the Sub routine then it will be available to all Sub routines in this Module and if I make it Public then it will be available to all Modules

Does anyone use this routine, if so do you know if it is possible in VBA to check to see if it is already running, if not then start it and then at the end of the routine to close it

Please help, I am getting a bit confused. If I want a variable to be only available in the current Sub routine then I use Dim, If I want the variable to be available in all Modules then I use Public. Does it matter if I make the statement is before or after the beginning of the Sub routine? What...

This (feature) was introduced to Outlook when Mr Gates updated to SR1, thank you very much Mr Gates. The only way that I have found to overcome this is a routine called Express ClickYes http://www.express-soft.com/mailmate/clickyes.html please post a reply if you find something better. Good luck

When I send an email using VBA, I found that the copy in my sent items does not contain the body or any attachments, I do need a proper copy of any emails that I send, does anyone know of a way to overcome this problem please ?

Hi, The routine is written in Access XP, I have found a utility called Express ClickYes, it works buy automaticaly clicking on the Yes box but it still has to wait 5 seconds for each email.

Please help, I have written my first major VBA routine to send emails with attachments to customers, but for every one of the 150 emails being sent Outlook pops up with the message “A program is trying to send mail using Item.Send”. I can click Yes but not 150 times, and with a 5 second delay on...

Please help, I have created a working Access VBA routine that searches through a query for customer Email Name and Product Type in that order and sends an email to each customer with a data sheet for each product attached. There are 9 different data sheets held as Word templates and each...

Thanks Ben, I changed it as you said but it still get stuck in the same place Sub Start_Proc() Dim DocsMail As String DocsMail = "C:\DocsMail\" Dim WordDot As String WordDot = "c:\Test.dot" Dim WordDot2 As String WordDot2 = "c:\Test2.dot" Dim strName As String Dim...

Please help, this routine will work the first time it is run, the 2nd time it will fail at the first "Selection." statment with the error Run-time error '91' Object variable or With block variable not set. What have I done wrong? Another error message I sometimes get is Run-time...

Has anyone else got a solution to my problem please ?

I found that it would accept: Set docType1 = objWord.Documents.Open(WordDot, , ReadOnly) But then "docType1.Select" would not work

Thanks Shane, I tried something like that but it wont accept "objWord.Open" in the 4th line: When I tried to run it it gives the error: "Method or data member not found" Dim objWord As Word.Application Set objWord = CreateObject("Word.Application") Dim docType1 As...

Please help, I have a routine that opens a Word doc from Access, but now I want to open 2 documents at the same time. How do I set 2 variables so that I can activate one, then switch and activate the other? Public Const WordDot As String = "c:\Test.dot" Dim objWord As...

Please help, I have 2 questions. 1/. I want my routine to send all .doc files in a folder to a contact but how, the Attachments.Add will not allow me to put “c:\docsemail\*.doc 2/. I want to start Outlook before running this sub routine because it is part of a loop, it will be very slow if I...

Thanks Rick, I do use these commands but they mean I have to reload the Template after saving each doc, what I wanted was to open the Template, Save the changes to a new doc, close the new doc but still have the Template open. If I can do this it will save loads of time and processing.

Please help, I am writing a VBA routine in Access to send emails with 1 of more attachments based on the same Word.Dot template. The idea is to open the Word template, make some changes and then SaveAs into a temp folder, then when ready email the attachments, clear the folder and then move onto...