vba

Hi All, I'm new here so please bare with me, I run multiple projects with multiple staff needing access to emails currently we just print the emails off and file them in a lever arch file. I'm wanting to create macro to export key details from an email to a project specific email register so...

This macro saves selected emails into a folder chosen by function "BrowseForFolder". It also adds the date as part of the filename. My issue is that the default start folder selected is always the same and I have to navigate to the folder each time. I want to use "msoFileDialogFolderPicker" to...

Working on a desktop and laptop; is there a method to keep the VBAProject.otm files in sync rather than just relying on my poor memory to copy and overwrite!? Peter H

I have a motion sensing security camera in my server room. It sends a mail message with a snapshot any time motion is detected. I'm trying to create a rules script that moves those messages received between the hours of 6am and 6pm to another folder (so I don't have to see them in my inbox...

Hi could someone help? I have a Add-in in Outlook (Newforma) that uses the Application_ItemSend function. You can send an email by clicking on Outlooks Send button or on this Addins button. I wanted to write a small msgbox to remind people to use the Addin when they click on Outlook's Send...

Hi All, The below macro works great and am triggering this when a email arrives. but sometimes i get "Error in rule" and rule stops. Any idea what causing this error ? Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt As Outlook.Attachment Dim saveFolder As String Dim...

Hi all, I am trying to make a script / rule / combination of both that only occurs when i receive an email from a specific address. I would like to copy the body of the address and edit two things: • there is a hyperlink'ed word, "website" (see attached). I would like to change the address of...

I located a code which creates an email message with a meeting attendee list including acceptance status. I installed the code and was able to run it without issue from both editor and developer tab macro list dropdown. I exported the code to be able to import onto another computer but now the...

Hi All, my first post here, i have this below code working great as it is searching email with subject line and replying to it. the same task can i search by "Attachment name" and make reply ? here is the code Try Dim olApp As Outlook.Application Dim olNs As...

Hi All, I am new here and looking for some support with VBA for outlook. Now i'm faced with a similar task of getting something done with outlook and I was hoping someone can help me out. Here is my situation: I have a team of 15 people that is split into 4 member groups and they all handle...

Diane Poremsky submitted a new article on Slipstick.com Autoaccept a Meeting Request using Rules Continue reading the Original Article at Slipstick.com

Diane Poremsky submitted a new article on Slipstick.com Close a Meeting When the Room is Full Continue reading the Original Article at Slipstick.com

Diane Poremsky submitted a new article on Slipstick.com Create a Task when a Message is Flagged Continue reading the Original Article at Slipstick.com

Diane Poremsky submitted a new article on Slipstick.com Save Selected Email Message as .msg File Continue reading the Original Article at Slipstick.com

I know that I can link tasks to OneNote. The problem is that the body text of the task is not copied to OneNote. For us this is a must as I do not want to switch over all the time to OneNote (especially during travel/with customers). Printing is an option but, it only prints an image which...

Diane Poremsky submitted a new article on Slipstick.com Batch Import Photos into Outlook Contacts Continue reading the Original Article at Slipstick.com

Diane Poremsky submitted a new article on Slipstick.com Export (Save) Outlook Contact photos Continue reading the Original Article at Slipstick.com

Hello. I am using Office 2013. I have excel vba working great except for outlook doesn't attach the file 100% of the time. Sometimes it attaches and sometimes it doesn't. It only acts up for remote (out of the office) individuals. The excel macro runs and attaches an email in outlook and saves...

Diane Poremsky submitted a new article on Slipstick.com Save Messages and Attachments to a New Folder Continue reading the Original Article at Slipstick.com

Hi, I am trying to make outlook search for specific key words in .txt attachments then move the emails with those attachments to a folder. The only way I was able to get some results is by using SendKeys. Code works up to he third line but when I add the last 2 lines and run I only get the...