Recent content by bmcilroy

I've already gone to that particular site and posting, but since I'm not over versed in VB, I can't seem to manipultae it to get it to work. Any chance you could help me with the code?

I have looked all through tek-tips and all over the web and am having problems creating a simple solution to upload a file to my website. I have VB code inside an Excel module that does multiple things. Saves, prints Adobe files, imports data to Access, e-mails, etc... Now I want to upload a...

Jerry, Here's the updated code below; I'm getting the following error: "Run-time error '2147217900 (80040e14)': Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', OR UPDATE' _________________________________________________________ Sub Mass_Email() Dim myList As...

Tony, Since you're clearing a good programmer, can you help me with some e-mail automation within Access? Please see thread below. thread707-1269679

How do I use the results of an Access Query "Query Name", which are a bunch of e-mail addresses, to send out an e-mail within the following code? ___________________________________________________________ Sub Mass_Email() Dim NewMail As Object Dim objmail As Object Set NewMail =...

Tony - Please go to my website (address above) and find my e-mail address. I need your mailing address so I can send you a "small" thank you present.

Tony - YOU ARE AWESOME!!! Everything works GREAT!

Tony - When I define them as: Dim newMail As Outlook.Application Dim objmail As Outlook.MailItem I get the following message: "Compile error: User-defined type not defined" at the Dim statement When I define them the other two ways, I'm getting the same error message at olMailItem. Based...

Tony - My second set of code does not require defining my named cells (example: email = Worksheets("Input").Range("I5").Value). My first set I do have to define (Example: Dim email As String). After inserting the second set of code and defining all Strings, I'm getting a "Compile error...

Oops - forgot to post code. Here are the links to my .rtf files that have the two modules. First module: http://truthbenefits.com/Forms/Initial_Quote.rtf Second Module: http://truthbenefits.com/Forms/Initial_Quote_2.rtf

I've created a program in Excel that has VB driving automation. I have two separate modules that work perfectly well. The first programtically prints adobe files, saves them and the Excel file to designated folders, opens Access and runs a macro to import data from the Excel file into Access...

I have successfully automated printing an Excel sheet using VBA to a defined sub-directory using Adobe 5.0 (utilizing pdfwriter). I bought Adobe 7.0 and can not figure out which registration files to manipulate to achieve the same results using the Adobe PDF. I need 7.0 for some of the...

Good morning djRixMix. Any chance we can adapt this to printing a sheet from an Excel file? I'm sure it can be done, but I need your help. Thanks in advance.