automate email

Hi, The below is part of a larger macro than generates an e-mail with an image from an Excel sheet as well as some text and the file as an attachment. Set OutMail = OutApp.CreateItem(0) With OutMail Set olInsp = .GetInspector Set wdDoc = olInsp.WordEditor Set oRng...

Hi Everyone, Can anybody help me to create macro as per below requirements 1) i need to send email notifications to customer, with the template of particular sheet 2) As per email id, order number, sheet name mention in column A,b,c 3) In body of mail need to select sheet which is mention in...

Hello everyone i have assigned a task in the office , i already know the vba code to send mail via outlook and i knew everything is predefined inside the vba code (TO,CC,BCC ,SUBJECT and and BODY).but the issue now is i need to create a userform with combox and extract the value selected in...

Hello all, I'm working on a macro that: - reads an excel column of email addresses - sends an email through Outlook to 5 of them at a time, bcc'd - waits 60 seconds before moving on to the next 5 email addresses - repeats this operation until the end of the column has been reached This is a...

Hi, thanks for taking the time to read this problem. I'm trying to build a spreadsheet which will be used every time a new contract is booked centrally to email the offices who will receive it, and tell them what they need to know about it. I have one sheet which is just a big email list that...

Morning, Hoping someone can help identify how to work around this. I have the Windows 7 Task Scheduler open an excel file, it runs an on open macro that calls Refresh_all_tables, does what it needs and closes. However, it is now locked, I've tried changing the Application.Quit...

I have been browsing solutions for this problem but cant figure it out. This code limits the string so the email cuts off the complete text past a certain length. Whats the best workaround for the 255 character limit? Can I create an array http://support.microsoft.com/kb/105416 ? Private...

Hello Mr Excel fans, First post here so break me in gently. I have a folder with numerous spreadsheets, for arguments sake lets say North.xls, East.xls, South.xls and West.xls . Each file contains one sheet that has the same name as the file is named. Now, I have a seperate spreadsheet...