outlook 2010 & vba

Hi Guys, I was just wondering if there is anyone out there that can help me please. I generate a report for customers which has order progress updates on it along with email addresses that are shown as hyperlinks in the first column. I was just wondering if anyone knew if there was a way of...

I have 30 excel file saved on hard drive, and want to sent these file through outlook. every file will be sent on different email address. Please help

Hi group, Please advise me if this is the wrong forum to post to. I've been working to have the VBA code inside an Excel spreadsheet to create a new Outlook email and then paste some copied data from that spreadsheet into this new email. It seems to be doing everything I need it to do except...

Hi, I have multiple outlook emails which contains doc and pdf files. Each email has it's own subject and on that basis it has to create the folder and convert the outlook email and it's attachment need to be saved in the same folder after converting it into 1 pdf. Step 1: I'll save all the...

I would like to have a script that takes the email address ex. "Fake_Name@example.com" & sets the attachment to "Fake_Name" then saves that file to a set folder. I am struggling with capturing the email address. Is this possible? Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt...

Hi Guys, I have a path (Folder) and it contains the multiple excel files (say abc.xls , asd.xls and so on) Once I run the macro if folder "contains" abc file name then it has to auto generate the email draft with the respective email id. In sheet 2 I have mentioned abc and it's respective...

Hi all, Im not the greatest with Excel VBA but i have put together a small programme to send an excel range via an Outlook email using send keys and then to return to excel and do something else. The progamme works perfectly in isolation (Excel to Outlook -End) But when i add excel code to...

I found some information on the forums in regards to sending emails from excel using VBA codes, and the code works fine, the issue I am running into is how do I avoid having to press send when it opens outlook for say 108 emails, and also the code seems to skip addresses. I'll post the VBA I...

Hi guys, I am trying to create a Macro in Outlook for my daily call centre reporting. There is an inbox and then a folder where each agent keeps their completed emails. The figures that I report are as follows: Emails received (by date) Emails Open Date of oldest open email I've managed to...

Hi Everyone and thanks in advance for the help. I am relatively new to basic but really want to learn. I know I can count on you guys. I do not know how to approach this. I need a macro which can do the following 1. saves excel worksheet to a folder 2. replies to an outlook mail (criteria: the...

Hi, I'm trying to get excel to run a macro that sends me an email when certain cells reach specific dates (current date and one week prior to current date). I've tried following the steps on Send a mail when a cell reaches a certain value but it doesn't work. I need excel to send me an email...

I have the below VBA code which i run to create a reply email. <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space...

Hi again, and thank you for taking the time to check out my problem. I am still not confident using VBA but have tried to amend code to enable me to get the functionality I am after, but I have failed. I'll try to break it down for easier reading (hopefully). The objective: Whenever a user...