outlook 2010

Hi, I'm trying to build a macro that grabs a selection of cells from an excel spreadsheet, pastes the cells into a new outlook email, then changes the format of the cells. Specifically I want to convert the table to text, then change the font to Arial size 10. The code below does the above...

I've search the internet for what I'm needing but I've come up short. Basically, I have a userform with a button and two textboxes. When I press the button, it should search for email subjects that CONTAINS the keyword in the txtbox1.value. Most of what I've seen on the internet is code for...

I found this code online, which works great for moving all excel files from my outlook subfolder, into a folder I have already have created on my C drive. I was wondering if there is a way to create a new folder on my C Drive based on the excel files in my subfolder. If the excel files in my...

Hi, we have a macro attached to company documentation that works as a validation, when clicking OK an email with the link to the document is prepared for the next person in the validation chain. This is already solved. The thing is that often several documents must be sent together and not...

Hi there, I am using a PC with Microsoft 10 at work. I couldn't find a code online that would do exactly what I need. Sorry that I have no code to offer. DETAILS: 1) The set of PDF's to be emailed will be in the same folder. 2) There will be several PDF's in that folder, but I may only...

Hi, I have a huge database of items in an excel sheet which i should be able to look up automatically when i receive an email. Is there anyway i can do that using macros.

Hello. Is there a setting that I can use to add a default subject line to my saved contacts when making outbound mail using Outlook 2010? I want the default subject line to live in the saved "contact". Thank you!!

Hi, So far i have managed to link access to outlook via a hyperlink on the email address, click it and it brings a blank email with just the 'To' field populated. What i want to do is have a generic email template, so when the email address is chosen (via a form which looks at a table) then it...

I am trying to put in the following code to send a meeting request when an employee clicks a command button on a userform When I attempt to click the userbutton it gives me a compile error: Expected End Sub I can't really figure out why it's giving me this error as I have command buttons with...

Looking to be able to set up an outlook rule that sends emails based on a number found in the body of an email. That number corresponds to a particular email address. For example: An email comes in that contains "800000" in the body. Outlook would then reference a spreadsheet that says 800000 -...

Hi Guys I'm almost brand new to VBA coding in excel and was wondering if someone could assist with an e-mail task. I need my macro to send an E-mail using outlook 2007+ to a group set up in outlook with only a predefined subject and a predefined signature. the macro does the following: upon...

Hi, I have columns of information that I would like to have a macro open up the email based on criteria and insert all the fields and then leave it open so that I can attach a pdf to the email. <colgroup><col><col><col><col span="4"></colgroup><tbody></tbody> <colgroup><col><col><col><col...

Hello All, Please let me know how can I copy body of the e-mail to Text document without changing the format by VBA automatically when the e-mail arrives with a subject "Test" regards, sai

Hi Everyone, Complete VBA newbie here. I have the following code for sending out an outlook email with an attachment, and there's one line in the body (cells(9,2) particularly) I would like to bold+underline. Please help! Much appreciated. Sub Email() ' ' Dim OutApp As Object Dim...

Hi, We have one manual activity where if a user requests for access to any specific folder we reply to their email by providing them a link to fill the form and submit it for approval. In a day we receive nearly 10-15 emails. I want to know if its possible to send an automatic reply to...

Hi friends - Good afternoon to all. Sorry if this marks the commencement of amateur-hour here on MrExcel.com, but I'm a rookie and a first-time-poster long-time-reader, so I'd be incredibly grateful if someone could hook me up with some knowledge. I have a problem that's been gnawing at me for...

Afternoon gents, Could i please have some guidance on the following macro. What i would like it to is reply to the email selected with a personalise template. Here is the code i have at the moment. Public Sub software_request() Dim oMail As MailItem On Error GoTo blad Select Case...

Hello, Please can someone help me - I have been trying to do this for three days and am thinking it is impossible but I know it must be possible so is getting very frustrating! I have a form in excel (very simple) that I need to put on the web - People can then fill out certiain bits of the...

Hello, and thanks in advance. Every day I get emailed a table in HTML format. Copy and paste works, but I was wondering if anybody had any clever ideas on how to get excel to do this on its own? The email comes from the same address and the table is 6Rx7C including headers. Thanks for looking!

Hi I am new to VBA (macros) and although I have found a lot of code on the internet that appears to do what I need as I not really familiar with the code I am not sure what it actually does. I have my emails set up under sub folders in my inbox. I have several rules applied so that emails go...