Search results for query: *

I should clarify....Instead of using objMail.attachments.Add ("H:\TestFile.txt") I would like to use the code your provided to replace it but I am just not sure how to merge it with the existing code that I provided.

How would incorporate that into my existing code. Dim objOutlk 'Outlook Dim objMail 'Email item Dim strMsg Const olMailItem = 0 'Create a new message Set objOutlk = CreateObject("Outlook.Application") Set objMail = objOutlk.createitem(olMailItem)...

I have created a script that saves the curent workbook to my temp. drive. After this action is perfromed I then start Outlook and scripted the email and distribtution list for the appropriate reciepiants of the report. My question is since the file will be the latest file saved in the temp...

I am moving columns from one worksheet to another. In doing so I am using the scrip to copy the entire column. ColumnsToCopy = Array("State", "City", "Address", "Phone") Set SourceSht = ActiveSheet Set newWbk = Workbooks.Add Set NewSht = newWbk.Sheets(1) NewSht.Name =...

Awsome...thanks for the help.

Thanks...I got the report to save accordingly. How would I go by adding a space between the report name and date. As of now they are merged together. TempFileName = "Student Report" & Format(DateSerial(Year(Now),Month(Now),0), "mm-yyyy") Which reads as: Report03-2010 Thanks!

I am trying to create a script that will allow for me to to save a file as the previous month and also display the corresponding year. The script that I have below is getting me close to what I want but its saving the file as the current month. I know that what I have below isnt going to yield...

I have a worksheet that has almost 50 columns and the list is forever growing. For reporting reasons I only need to use some of the columns. Does anyone know of a script that will allow me to indentify the columns that i want to keep and delete all of the other remaining columns? For example...