Computer Support Forum

Solved: email > triggers Outlook macro > triggers non-Outlook macro: any help?

Question: Solved: email > triggers Outlook macro > triggers non-Outlook macro: any help?

Hi,

Is it possible for an email to trigger an Outlook macro and then for that Outlook macro to trigger a macro, which is external to Outlook (and Office)?

I'm using Outlook 2007

More replies
Relevance 100%
Preferred Solution: Solved: email > triggers Outlook macro > triggers non-Outlook macro: any help?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 118.61%

My requirement is, when i receive a new mail in outlook, it should trigger a macro which saves the new mail info (Sender address, date received, subject etc..) in an excel sheet. I have a macro code which does just that, but it only works for personal mailbox. I want to mimic the same steps for shared mailbox. Here is the code which works perfectly fine for personal mailbox,

PrivateSub Application_NewMailEx(ByVal EntryIDCollection AsString)

Dim varArray AsVariant
Dim strSub AsString
Dim strBody AsString
Dim strArray()AsString
Dim lngLoop AsLong
Dim objItem AsObject
Dim lngMailCounter AsLong
Dim objMItem As MailItem
Dim xlApp As Excel.Application
Dim wb As Excel.Workbook
strArray = Split(EntryIDCollection,",")
For lngMailCounter = LBound(strArray)To UBound(strArray)
Set objItem = Session.GetItemFromID(strArray(lngMailCounter))
If TypeName(objItem)="MailItem"And InStr(1, objItem.Subject, strSubjectLineStartWith)And InStr(1, objItem.Body,"")Then
Set objMItem = objItem
Set xlApp = GetObject(,"Excel.Application")
Set wb = xlApp.Workbooks("test2.xlsx")
With wb.Sheets(1)
With.Cells(.Rows.Count,1).End(-4162)(2).Resize(1,7)
.Value = Array(objMItem.SenderEmailAddress, objMItem.To, objMItem.CC, objMItem.BCC, objMItem.Subject, objMItem.ReceivedTime, objMItem.Body)
EndWith
EndWith
Set objItem =Nothing
EndIf
Next lngMailCounter
IfNot IsEmpty(strArray)Then
Erase strArray
EndIf

EndSub

I am not well-versed with ... Read more

Answer:Outlook Shared mailbox - new mail triggers macro

Instead of using the New_Mail event to trigger the macro try setting up a custom rule to trigger the code.
 

1 more replies
Relevance 110.78%

hi all,

I would like to be able to find some software that would allow my computer to automatically click certain buttons on my screen after a specific email is sent. The reason for this is that I have have investments and unfortunately the spreadbetting company I am with only notify you via email when certain criteria are met but do not initiate any action. Obviously I don't stare at my email constantly checking for these alerts and since these are opportunities that last for only a few minutes I need a macro to be able to take advantage of these situations.

By the way I have no knowledge of programming and scripts so any answers involving them could they please be carefully explained.

Thanks!!
 

More replies
Relevance 76.85%

I have created an evaluation in MS Word and would like to include a checkbox at the end of the evaluation in which once clicked on (using a macro), the form is sent via outlook as an attachment to a specific email address. I have looked through tons of macros and VB scripts but cannot come up with exactly what I am looking for. I'm pretty sure this is an easy code to come up with, but I am not that strong in using VB. If anyone can help, please let me know!!!
 

More replies
Relevance 76.85%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.
 

More replies
Relevance 76.85%

Hi,
I send multiple emails all with the same information in the subject field. No, I'm not spamming. I'm sending order confirmations. I would like to set up one of the function keys on my keyboard to automatically populate the Subject fields.

Example:
Open a new email
Curser is in the Subject field
Automaticlly populate "THank-you for your Order"

I found a section for Macros in the Tool bar but am clueless. ANy help would be much apprecaited. THanks!

PS: running MiccroSoft Outlook 2000 and Windows XP
 

More replies
Relevance 76.27%

G'Day everyone,

Firstly, thank you for this super-awesome website. I can spend my whole day trawling through the gems here which make my life so much more easier!!

I have a question:

I am trying to write an Outlook 2007 Macro which has me a bit stumped.

We get a system generated email which tells us which staff is late for which department. The Managers then send an email to their departments only extracting the info from this email.

I have a rule currently set up which dumps this daily email to the "Sick and Lates" folder. I then go there everyday at 9:30 am, copy the names of the guys in my department and send an email to the DL.

I am trying to automate this so that whenever a sick and late email arrives, Outlook will pick up the names of the people in my department only, chuck them in a separate email addressed to a specific distribution list and fire away.

I had a look at other posts but am stumped.....help, please?

 

More replies
Relevance 76.27%

I'm working in a ticketing system that requires me to copy and paste emails along with headers and whatnot to tickets. Right now I click "reply" and copy and paste and close the 2 windows. I was wondering if there's a way that copies all the data of an email into the clipboard to save myself a considerable amount of time on a day to day basis.

Answer:Outlook 2010 macro to copy email to clipboard

Copy email to the clipboard with Outlook VBATony

5 more replies
Relevance 105.37%

Dear All,

I am using Outlook 2003 and receive many emails a day with huge attachments, you all know what that means.
I am looking for a macro that I can run on a specific inbox folder to store all attachements of that email inbox subfolder into folders on my harddisk. But the macro should create subfolders with the senders names so that I can easily find the attachments and asign them to emails. The makro should also add a comment to the email that the attachement has been stored on a certain date to the HD.

Does naybody have an idea how to solve this ?

Thanks
Andie
 

More replies
Relevance 105.37%

Hi all,

I need to know if is it possible that a macro in Excel sends an email containing the visible cells using Microsoft Outlook.
btw, I saw some code on the internet, that saves the visible cells in a new excel file and attach it in a new email using Microsoft Outlook, but I don't want to have attachments in the email.

thanks for any possible help.
 

More replies
Relevance 105.37%

dear all
i need a macro to list out the email that received today n to show they are responded or not
thnks
mv
 

More replies
Relevance 102.5%

Can anyone tell me how to create a macro in Outlook 2003 that will search the junk folder for certain words in the subject line, and if found permanently delete the e-mail?

Any help with this will be greatly appreciated.
 

Answer:Solved: Outlook 2003 Macro

15 more replies
Relevance 102.5%

I have a Macro that will delete the junk folder by a certain criteria, and then delete the delete folder by certain criteria.
Code:


Private Sub Application_Startup()

Dim objMapiName As Outlook.NameSpace

Set objMapiName = Application.GetNamespace("MAPI")

Set vFolder = objMapiName.GetDefaultFolder(olFolderJunk)

ReLoop:

For i = 1 To vFolder.Items.Count

Set myItem = vFolder.Items.Item(i)

If InStr(UCase(myItem.SenderEmailAddress), "BADWORD1") > 0 Then
myItem.Delete

GoTo ReLoop

End If

Next i


Set vFolder = objMapiName.GetDefaultFolder(olFolderDeletedItems)

LoopDeleted:

For i = 1 To vFolder.Items.Count

Set myItem = vFolder.Items.Item(i)

If InStr(UCase(myItem.SenderEmailAddress), "BADWORD1") > 0 Then
myItem.Delete

GoTo LoopDeleted

End If

Next i

End Sub


However, the macro actually runs before the e-mail(s) have arrived when first started up. Is there a way to have the macro after the e-mail(s) have arrived?
 

Answer:Solved: Outlook 2003 Macro

8 more replies
Relevance 102.5%

I have the following code:
Code:

Option Explicit

Private Sub NewMailEx(ByVal EntryIDCollection As String)

'Replace "BADWORD1" with actually word. Most be in all UPPERCASE.

Dim objMapiName As Outlook.NameSpace

Set objMapiName = Application.GetNamespace("MAPI")

Set vFolder = objMapiName.GetDefaultFolder(olFolderJunk)

ReLoop:

For i = 1 To vFolder.Items.Count

Set myItem = vFolder.Items.Item(i)

If InStr(UCase(myItem.SenderEmailAddress), "[email protected]") > 0 Then
myItem.Delete

GoTo ReLoop

End If

Next i


Set vFolder = objMapiName.GetDefaultFolder(olFolderDeletedItems)

LoopDeleted:

For i = 1 To vFolder.Items.Count

Set myItem = vFolder.Items.Item(i)

If InStr(UCase(myItem.SenderEmailAddress), "[email protected]") > 0 Then
myItem.Delete

GoTo LoopDeleted

End If

Next i

It was working fine, but all of a sudden it just stoped working. When I open "Microsoft Visual Basic Editor", I go to Debug -> Compile Project1 I get an error message that the following variable is not defined.
Code:

vFolder =
 

Answer:Solved: Outlook 2003 Macro

Remove the "Option Explicit" line from the top of the module. When you include this line of code at the top you are required to declare your variables.

Regards,
Rollin
 

2 more replies
Relevance 101.68%

Hey guys, I am quite new to creating macros. I do have some primitive experience with code. My goal is to take 3 or 4 colums of information and put them into Outlook Calendar.

A- Discription B- Start -C Finish

So, in the Calendar in outlook it would show a discription and connect the dates in B and C to the days in the Calendar. I don't know if it can be done. At my current state I can't figure out how to get even one to move over. Any suggestions on where to start??

I am running Outlook and Excel 2003 all updated. On Windows XP Pro Service Pack 2.
 

Answer:Solved: Excel Macro to Outlook Calendar

16 more replies
Relevance 101.68%

Howdy, folks:
I'm trying to use an Outlook macro to initiate an Excel routine. I've taken a look at geek123 and rollin_again's conversation that would seem to be on point for what I'm doing. I've somewhat modified the recommended code - attached below:
Private Sub Application_NewMailEx(ByVal EntryIDCollection As String)
vID = Split(EntryIDCollection, ",")
For i = 0 To UBound(vID)
Set objMail = Application.Session.GetItemFromID(vID(i))
vSubject = UCase(objMail.Subject)
vFrom = objMail.SenderEmailAddress
If Left(vSubject, 1) = "C" Or Left(vSubject, 1) = "D" Or Left(vSubject, 1) = "L" Then
Set xlApp = CreateObject("Excel.Application")
Set xlWB = xlApp.Workbooks.Open("c:\stubbs\test.xlsm")
Set xlSheet = xlWB.Sheets("Sheet1")
vRow = xlSheet.Range("A" & xlApp.Rows.Count).End(-4162).Offset(1, 0).Row
xlSheet.Range("A" & vRow).Value = vSubject
xlSheet.Range("B" & vRow).Value = vFrom
xlWB.Save
xlApp.Quit
Set objMail = Nothing
Set xlApp = Nothing
End If
Next i
End Sub
The code errors out while trying to open the workbook, saying that it couldn't find the file. I've checked the pathing and the filename and they're correct. Has the format for the open statement changed?
Thanks for you help.
Bob
 

More replies
Relevance 100.45%

Hi, I am looking for a macro to import contacts from excel. We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I would like to create the macro for all the team so that they can periodicaly update their contacts. I trust this makes sense
Thanks
Moved to Business Applications.
 

More replies
Relevance 100.45%

Hi there,

Previously I requested assistance in trying to get a macro for Outlook 2003 that when I compose a new email in Outlook 2003, the date will appear in the subject line automatically in the following format:
20101009-

Member Rollin_Again very kindly gave me the following data:

Sub CreateMail()

Dim objOutlookMsg As Outlook.MailItem
Set objOutlookMsg = Application.CreateItem(olMailItem)
objOutlookMsg.Subject = Year(Date) & Month(Date) & Day(Date) & " - TEST SUBJECT"
objOutlookMsg.Display

End Sub

It works apart from now a new year has started, the month only date only appear as a single figure if less that 10 (eg 201011 rather than 20100101)
I have tried editing with it but no joy.

Can anyone help please?
 

Answer:Solved: Editing Macro Date for Outlook 2003

9 more replies
Relevance 99.22%

Ok, just a bit of advice needed on this one for the time being...
I need a macro that will:

- Save all (Excel) attachments from the currently open email message (or a message selected in the Inbox) to a directory on the PC.

- Merge all the saved Excel files into a single file - they're all formated exactly the same - data in about 20 columns, no column headers or anything, just standardised data.

- Save the merged file with a standard name (i.e. every time this is ran, it needs to have the exact same filename).

- Delete all the files in the directory apart from the merged file.

I know there's probably a fair bit of code online for doing the individual parts of this. Can I do both from within Outlook? It doesn't particularly matter if I need to do this in 2 steps - an Outlook macro to save the attachements, and an Excel macro to do the file merge etc.

Cheers.
 

Answer:Solved: MS Outlook / Excel macro - extract attachments and merge

16 more replies
Relevance 98.4%

Hi,

We have a spreadsheet that keeps track of when our computer warranties expire. Would like to run a macro using the warranty expired date to create an appointment in Outlook. That part I understand. The problem is that when I go to run the macro again, it creates a duplicate appointment if the appointment already existed. Very frustrating!

This is the code below, any help would be appreciated!!!! Thanks
Sub AddToOutlook()
Dim o As Outlook.Application
Dim ai As Outlook.AppointmentItem
Dim r&, sSubject$, sBody$, dStartTime As Date, dDuration#

For r = 4 To 10

sSubject = Sheet1.Cells(r, 1).Value
sBody = Sheet1.Cells(r, 4).Value
dStartTime = Sheet1.Cells(r, 3).Value
dDuration = 30
Set o = GetObject(, "Outlook.Application")
Set ai = o.CreateItem(olAppointmentItem)
ai.Body = "Service Tag= " & sBody
ai.Subject = "Warranty Expires for Server " & sSubject
ai.Start = dStartTime
ai.Duration = dDuration
ai.Close olSave

Next r
End Sub
 

Answer:Solved: Excel Macro to Update Outlook Calendar Creates Duplicates

6 more replies
Relevance 97.17%

Hi,

I need help with a macro. So far the macro is operating as it should , creating MS Outlook 2010 calendar appointments using data from an excel data spreadsheet (data base). The issue I’m having is that every time the macro is run for a new entry, duplicate calendar appointments are created for the already existing data in the data base. I would like to have the macro do a search to ensure an appointment does not exist before creating one. I have read a few threads with similar problems but have had major issues incorporating the solutions to resolve the issue I’m having.

I have attached the macro in txt. format for reference.

Thanks for your help.

kkfonty
 

Answer:Solved: Excel macro updating Outlook calendar is creating duplicate appointments.

Hi
You can use this function to check if an appointment exists based on the Start Day/Time

Code:

Public Function CheckAppointment(ByVal argCheckDate As Date) As Boolean

Dim oApp As Outlook.Application
Dim oNameSpace As Outlook.Namespace
Dim oApptItem As Outlook.AppointmentItem
Dim oFolder As Outlook.MAPIFolder
Dim oMeetingoApptItem As Outlook.MeetingItem
Dim oObject As Object

On Error Resume Next
' check if Outlook is running
Set oApp = GetObject("Outlook.Application")
If Err <> 0 Then
'if not running, start it
Set oApp = CreateObject("Outlook.Application")
End If

Set oNameSpace = oApp.GetNamespace("MAPI")
Set oFolder = oNameSpace.GetDefaultFolder(olFolderCalendar)

CheckAppointment = False
For Each oObject In oFolder.Items
If oObject.Class = olAppointment Then
Set oApptItem = oObject
If oApptItem.Start = argCheckDate Then
CheckAppointment = True
End If
End If
Next oObject

Set oApp = Nothing
Set oNameSpace = Nothing
Set oApptItem = Nothing
Set oFolder = Nothing
Set oObject = Nothing

End Function

For this to work you need to have Tools/References/Microsoft Outlook xx Object Library enabled.
Then alter your macro like this

Code:

Private Sub cmdOutApt_Click()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")
' Start at row 2
r = 2
Do Until Trim(Cells(r, 1).Value) = "&q... Read more

2 more replies
Relevance 93.89%

Hi guys,

Pretty new to Excel really, know the basic stuff but the intermediate stuff is beyond me for now. Hence this post.

What I want to do is this:

Have a field on my spreadsheet that contains a fixed date say 06/06/2008 and this cell would be green or a cell next to it would be green.

Now as the date reaches say 28 days in the future, so 04/07/2008 I want the colour to change to red.

Is this possible and if so, how do I do it???

Thanks,

Peaker.
 

Answer:Solved: Help. Need help with date triggers in Excel

8 more replies
Relevance 92.66%

I tried placing one of my favorite programs in the Startup folder but every time it starts it prompts for UAC confirmation. Annoying. Is there a way to get rid of this? (without disabling UAC. at the moment I work around this by completely turning off UAC but I feel nervous about this).

Thanks.
Geoff K.
 

Answer:Solved: Program in Startup folder triggers UAC

7 more replies
Relevance 92.25%
Question: Outlook macro

Hi,

i am using windows XP, outlook 2000
i want to write a macro which will transfer the received mail directly to the file server network folder.
Does anybody have ever tried it
Please reply
 

Answer:Outlook macro

From your Menu Bar, goto Tools, then Rules and Alerts - the rest should be self explanatory.
 

3 more replies
Relevance 92.25%
Question: Outlook Macro

I am trying to get a MACRO for Microsoft OUTLOOK to work. Basically the main function of the macor is to save an email to the specified directoy and save the email automaticaly as a .msg. But when compiling the macro I am geting a few error. Can somebody please help me fix this macro. Here is the macro:
Code:

Option Explicit

Public Enum olSaveAsTypeEnum
olSaveAsTxt = 0
olSaveAsRTF = 1
olSaveAsMsg = 3
End Enum

Private WithEvents Items As Outlook.Items

Private Const MAIL_PATH As String = "C:\mails\"

Private Sub Application_Startup()
Dim Ns As Outlook.NameSpace

Set Ns = Application.GetNamespace("MAPI")
Set Items = Ns.GetDefaultFolder(olFolderInbox).Items
End Sub

Private Sub Items_ItemAdd(ByVal Item As Object)
If TypeOf Item Is Outlook.MailItem Then
SaveMailAsFile Item, olSaveAsMsg, MAIL_PATH
End If
End Sub

Private Sub SaveMailAsFile(oMail As Outlook.MailItem, _
eType As olSaveAsTypeEnum, _
sPath As String _
)
Dim dtDate As Date
Dim sName As String
Dim sFile As String
Dim sExt As String

Select Case eType
Case olSaveAsTxt: sExt = ".txt"
Case olSaveAsMsg: sExt = ".msg"
Case olSaveAsRTF: sExt = ".rtf"
Case Else: Exit Sub
End Select

sName = oMail.Subject
ReplaceCharsForFileName sName, "_"

dtDate = oMail.ReceivedTime
sName = Format(dtDate, "yyyymmdd", vbUseSystemDayOfWeek, _
vbUseSystem) & Format(dtDate, "-hhnnss", _
vbUse... Read more

More replies
Relevance 92.25%
Question: Outlook macro

Can there be code written to open the 'To" button?
So if I hit the "New" button it would execute the To button right away?
Or add a button then set a macro to open the "new" message and open the "to" button.

Thank You,
Michael
 

Answer:Outlook macro

10 more replies
Relevance 92.25%
Question: Outlook Macro help

Hi

Can anyone help.

I am new to the world of Macros buthave managed to create one which fills in an email and adds attachments which is great.

The problem I have is when I open a new e mail via a hyperlink and then select the macro button, it just opens a new email, so I wnd up with 1 email with the To; box complete and 1 email with the Attachements and body content. This is driving me crazy!!!

Also Ideally I would like to have my default signature (and Banner) inserted as well but when the Body content is added it removes the default signature block. (I have found a work round which is reasonably user friendly and that is the Quick Parts but it is not ideal!)

I am convinced other people have had the same issues but I cannot find a solution at all.

Many thanks in advance.

The VBA I am using is below and works fine up to a point.

Sub PricelistInfo()
Dim olApp As Outlook.Application
Dim Msg As Outlook.MailItem
Set olApp = Outlook.Application
Set Msg = olApp.CreateItem(olMailItem)
With Msg
.Subject = " Initial Response (Attachments - (1) 2012 Pricelist + (2) Information Sheet)"
.Attachments.Add "C:\Users\Price List 2012.pdf"
.Attachments.Add "C:\Users\Information sheet.pdf"
.Body = "Here you go" & vbCrLf
.Display
End With

End Sub
 

More replies
Relevance 92.25%
Question: outlook macro help

Hello Everybody,
I have a small problem in outlook that I need a macro to solve.
Hopefully someone on here knows a lot more than I do about outlook macros and can give me some guidance.
I want to a macro to open an incoming email, copy the body of the email, paste it into a .txt file and save the file with a unique name. The name of the text file can be either a simple date/time stamp or the subject of the incoming email.

Any advice/help with be much appreciated

Thanks

Graham
 

More replies
Relevance 92.25%
Question: Outlook Macro

Hi

want a mcro that allows me to send the same message out at a paticular time every week day to the same recipients. How can this be done?
 

Answer:Outlook Macro

You can use a VBS script with Outlook to create and send the email. Copy the code below into a text file and rename with the extension .vbs

Then use Windows built in task scheduler (found in Control Panel) to call the script at your predetermined times. You can also create an Outlook template file and use Visual Basic to open and send it automatically.
Code:
Dim Outlook
Set Outlook = CreateObject("Outlook.Application")
Dim Message
Set Message = Outlook.CreateItem(olMailItem)
With Message
.to = "[email protected]"
.subject = "This is your subject"
.body = "This is the body"
.Attachments.Add ("C:\TEST.xls")
.Send
end with

Regards,
Rollin
 

1 more replies
Relevance 92.25%

is there anyway to copy macro's from word to outlook 2010, tried and got an error.
the type of macro that i'm talking abput are to switch different font's with a mouse click, size's or set sentences - words that have to be repeated many times (on many different days, so copy clips will not really help me).

Answer:outlook macro's - how

You can change the settings to use Word as your default email editor, then you can use the macro's inside word.

7 more replies
Relevance 92.25%
Question: Outlook Macro

Do you know if there is a way to write an Outlook macro that, when clicked on the toolbar, opens a new email with the subject line filled in automatically and a particular signature (which is setup already in outlook, but not as the default sig) put on the bottom?

Many thanks for you help

Nick
 

Answer:Outlook Macro

Maybe you could try the advice here:

http://www.google.co.uk/groups?hl=e...up:*outlook*&hl=en&lr=&c2coff=1&start=10&sa=N

Personally, if I ever had to use Outlook (hopefully never will), I'd try creating a draft, and copying it to the "Out" folder when required using CTRL+drag.

HTH,
Andy
 

1 more replies
Relevance 92.25%
Question: Macro for Outlook

I have setup a rule in Outlook 2003 or 2007 that will run a script when received from a certain sender. I need help with the script so that it does the following:

takes the email message (body) and inserts into another Outlook template (oft file) (like merging the two messages). the template is setup to have all the necessary instructions and data fields to be parsed when this message is sent to Remedy for auto case creation)..but it needs the details from the original email.

What I am trying to do is take a system generated email alert and get that info into an email that is properly formatted for Remedy to parse. And since I cannot manipulate the syntax of how the system generated email comes out I have to alter it after I receive it. I hope that makes sense... thanks, Steve
 

Answer:Macro for Outlook

Please post your existing code.

Regards,
Rollin
 

1 more replies
Relevance 92.25%
Question: Outlook Macro

I need a macro to segregate emails depending on the content of the body into Approved and Reject. (which is done by rules as of now)

at the bottom of the mail recieved there are 2 links one is for "Approved" and another is for "reject".
depending on the body content if it is "Approved" then the Hyperlink relating to "Approved" to be activated (webpage opens)
similarly for Reject
thanks in advance.
 

More replies
Relevance 92.25%

Hi,
I am writing an outlook macro to send automated mails to our employees. I want to use multiple lines in the message body. Can someone help me with the code to work this out.

Tks,Abhijit

Sub SendAnEmailWithOutlook()



Dim OLF As Outlook.MAPIFolder, olMailItem As Outlook.MailItem

Dim ToContact As Outlook.Recipient

Set xl = GetObject(, "Excel.Application")

Set w = xl.workbooks.Open("C:\pdf\data.xls")

Set ws = w.sheets("Sheet1")



Dim atch As Integer

Dim i As Integer

Dim e_mail As String



i = 1

For i=1 to 200

e_mail = ws.cells(i, 1).Value

atch = ws.cells(i, 2).Value

Set OLF = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderInbox)

Set olMailItem = OLF.Items.Add

With olMailItem

olMailItem.subject = "Change in Appointment Letter Clause"


Set ToContact = olMailItem.Recipients.Add(e_mail)

olMailItem.body = "Dear Employee,

Please note that we have modified a clause in the appointment letter regarding the confirmation process. Attached here is the letter with revised clause.



Request you to kindly sign and return a copy of the letter for our records.

Regards,

HR Team " & Chr(13)

olMailItem.Attachments.Add "C:\pdf\ & atch & ".pdf", olByValue, , "Attachment"

olMailItem.Send

Set ToC... Read more

More replies
Relevance 91.84%

Is it possible that a read notification feature would trigger the email to be marked as spam? If the answer is yes, and it is marked as spam and removed to the spam folder, will the email "read notification" indicate it was opened and read?
 

Answer:Solved: Read Notification triggers spam blocker?

Highly unlikely that this alone will cause an email to be "suspected" SPAM.

As to the read notifications, depending on the recipient, you may never get a "read notification" at all. Mine are disabled or I am prompted to allow or disallow.

If the person has the READ NOTIFICATIONS set to automatic and they open the email then it will send the READ RECEIPT back to you no matter what folder it is in.

Automatically moving a message to a folder will not trigger the receipt. If the person moves the email without a PREVIEW active, it will not trigger the receipt. If the person touches the email with the PREVIEW on, the message is marked as READ, then it will trigger a receipt.

Now, my experience shows that the RECEIPT is often detected as SPAM. As in I send an email to someone requesting a receipt, the read it, the receipt is sent.... often the receipt itself ends up in the SPAM folder because it is usually sent with an administrator email address.

It also depends on the mail program, webmail interface, the provider, and many other factors.

Thanks!

Shane
 

2 more replies
Relevance 91.43%
Question: Outlook 2003 macro

Hey guys

Are there anyone here that know how to make a macro in outlook2003.

Im looking for a macro that will put a standard text into an email message, and if possible have a hotkey to activate it with.

Thank you in advance....

Dan
 

Answer:Outlook 2003 macro

6 more replies
Relevance 91.43%

Hello,

I am still getting used to the microsoft visual basic coding for Microsoft Outlook. Could someone help me out with a macro for the following?

All requests for my team come into a group inbox and I would like to create a macro to have the request come to the group inbox, but the requests are worked out of the indivudual specialist inbox.

When the Macro button is pressed
1) It will go into the inbox, grab the last/oldest email in the inbox and forward/move it to a certain outlook email address. (Would be great if it could just be moved so that the requestor would still be on the email or else it will be coming from the group inbox).
2) If the macro can move the email that would be great, but if it has to forward then i need the macro to delete the email out of the group inbox.

Let me know if you have any questions about this macro.

Thanks,

Jeff
 

More replies
Relevance 91.43%
Question: Outlook 2007 Macro

Like many people I guess I have a habit of my fingers sometimes working quicker than my brain. One of the things I do regularly is send an email that is supposed to have attached documents and I hit the send button before actually attaching them, frustrating for me and the recipients.

A friend of mine had the same problem and he sent me a short bit of VBA code that, on his machine, checks any outgoing message for the word 'attached' and if it finds it, it looks for attachments if it finds them then well and good and off the message goes and if it doesn't then it flashes up a message box.

It works fine on his machine but doesn't on mine we are both using corporate machines, same Windows 7 and are tied pretty tightly by our IT department. Obviously there is something different on his machine, probably a security setting somewhere, anyone know where ?

If you are interested the code is :

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
If InStr(1, Item.Body, "attached", vbTextCompare) > 0 Then
If Item.Attachments.Count = 0 Then
answer = MsgBox(" This email has no file attached." & vbNewLine & " Do you still want to send?", vbYesNo)
If answer = vbNo Then Cancel = True
End If
End If
End Sub
 

Answer:Outlook 2007 Macro

10 more replies
Relevance 91.43%

Hello!

I've designed a spreadsheet in excel that can automatically send text messages to everybody in my workplace. This spreadsheet can also confirm replies from the people within my office with conditional formatting. The process is very fluid and really only has one kink.

MS Outlook is used to send the text messages. When a reply comes in to my inbox, it is placed in a folder called "Recall" using auto-rules. Once the replies are in the Recall folder I can manually output the contents of the entire folder into a file named "replies.csv". Once this file is outputted, excel pulls in the data automatically and updates the status of the RECALL.

Long story short...

I need a macro that runs in Outlook. This macro needs to be able to automatically export the "Recall" folder to a .csv file every time a new message is detected in the "Recall" folder. The macro also needs to export the "Recall" folder to a .csv each time a message is deleted from the "Recall" folder. I only want to export the FROM portion of each e-mail. I do not want to be prompted to overwrite the file each time.

Any assistance would be greatly appreciated! This will land me some big Kudos in the office!!

--Steve--
 

Answer:MS Outlook 2007 Macro NEED HELP

7 more replies
Relevance 91.43%

Friends,

I do not know how to write a Macro for Outlook but that's what I need. I am hoping to find someone advanced in this area that can do this quickly blindfolded. What I need is to run this Macro and it do the following:

1. I need it to append a text string of my choice to every calendar event in the subject. For Instance if I have a Calendar event at 2Pm today called "Meeting at Bank Of America" I would like to append to that and make it look like "Meeting at Bank of America 1".

That's all. I do not need it to look at a certain date range. This would be for all events. So in the example above I would tell it to add a "1" at the end of each event. Please help me on this if you can. I really appreciate it.
 

Answer:Outlook Macro Needed

I don't know how it works with Outlook, but you could try recording one and see what it does, then you can edit it for the other entries.
 

1 more replies
Relevance 91.43%
Question: Outlook 2010 Macro

I am looking for a macro that will go to a certain field in an open contact form. Specifically, I would like to be able to jump to the "User Field 1" located in the Miscellaneious Fields view of the All Fields tab. I want to assign the macro to a keyboard shortcut as well as attaching it to the QAT. I have recorded, worked with and modified macros in Excel and Word, but I have never attempted to write a macro in Outlook VBA. Eventually, I want to distribute this macro to other employees so everyone has the ability to view the field quickily, Some of the other users only have view rights (and not create or modify rights), but I wouldn't think it should affect the macro. I don't need guidancce on distributing the macro. Can anyone provide guidance on the macro and keyboard shortcut?
 

Answer:Outlook 2010 Macro

Outlook doesn't have an OnKey event so the closest you will be able to get is to add a custom button to your toolbar that will be used to fire your code and then you could assign a shortcut to the button. This would look just like any of the other built in shortcut options in Outlook where the first letter is underlined and to fire the macro you would just press ALT + the letter you assigned. Does that sound like it would work for you?

Rollin
 

2 more replies
Relevance 91.43%

Hi, any VB gurus know how to get this script to work automatically each time I compose new, reply, and forward messages in Outlook 2003?

Code:

Public Sub MyMacro()
Dim Mail as Outlook.MailItem

Set Mail=Application.ActiveInspector.CurrentItem
Mail.BCC = "your address here"
End sub


Thanks.
 

Answer:Auto BCC in Outlook macro

Hello admin types. I moved this thread to business apps to see if I could get more macro gurus to comment. You can delete this one.

Cheers!
 

1 more replies
Relevance 91.43%

I would like very similar macros that:
1. Add a second time zone to calendar (If this were Excel or Word, I could just turn on Macro Recorder and go to tool, options, etc.) I would like one for Eastern and one for Central. I assume I can easily make the second once I see the first.
2. Remove the second time zone.

I assume it is a matter of changing the properties of the form, much like I would do in Access, but haven't clue how to get started in Outlook.

If you can help, I would be very appreciative.

Robert
 

More replies
Relevance 91.43%
Question: Outlook 2013 Macro

I've created a custom button in Outlook 2013 for our encrypted messages that adds "Encrypt" to the subject and then gets flagged by Barracuda to send to the portal. What I'd like it to also do is when I hit my "Encrypt Message" button to receive a pop up box asking the user if they are sure they want to encrypt this message. Any help is greatly appreciated.
 

Answer:Outlook 2013 Macro

Could you post the script you've got so far please? I'm not familiar with Outlook but perhaps someone else here is - from what I remember from macros you'll need to use something like this before your code, then link vbYes and vbNo to your actions:


Code:
MsgBox("Are you sure you wish to Encrypt this e-mail?", vbYesNo + vbExclamation + vbMsgBoxSetForeground)
Here's a bit more info:
https://support.office.com/en-us/article/MsgBox-Function-e23511c8-4157-4e09-93a6-ba9f1749f4c0
 

6 more replies
Relevance 91.43%

I am trying to write a macro to archive e-mails as .txt files on our main server.

Within outlook you can assign a unique archive file path to individual folders by the following method:

right click on a folder and select 'Properties', select 'Autoarchive', check 'Archive this folder using these settings:', check 'Move old items to:' and browse for a file path.

Once the file path has been selected does anyone know how I can access this file path using VBA code?

Any help would be much appreciated - even directions to a more appropriate forum.

Thanks in advance.

Kevin
 

More replies
Relevance 91.43%

I am trying to do the following in outlook 2003 via a macro/script (in windows XP).

When an email comes in from a certain email address, i need to print it to a different network printer other than the default printer on the computer. This network printer is a roll paper printer, so it requires different page setup to print properly. I can get it all to print properly manually, but i need it to it automatically without any user interface, since the user is in a different area.

Outlook rule checks for email criteria & runs the script (i know how to do this).

Script changes default printer to the roll paper printer.
Script changes page setup to smaller margins.
Script prints the email message to the roll paper printer.
Script changes default printer back to original printer & page settings.

I am very familiar with VB in excel, but not how to use it in outlook to accomplish this.

Thank you very much for your help!
 

Answer:Outlook 2003 Macro Help

7 more replies
Relevance 91.43%

Hey guys, I had some great assistance from computerman29642 earlier on this macro. It works perfectly on my own calendar; however, I need to target a specific shared calendar. Hopefully it could be user imput by a msg box. I am struggling to find information on how to do this.

The first thread was this
http://forums.techguy.org/business-applications/835748-solved-excel-macro-outlook-calendar.html

So, as for now the example works. But before it writes to the calendar I want a msg box pops up asking for the desired calendar(Sometimes more than one word), and then target that calendar and write the data. A simple little box that confirms or denies progress (I am pretty sure I can figure that one out) Any suggestions or directions where I can learn more fire away please. Ill attach a copy of my test again.
 

Answer:Excel to Outlook Macro

16 more replies
Relevance 91.43%

to lessen the clicks when printing emails and attachment(s) - I need help in creating a Macro to print all - Outlook 2k3: Macro for printing email & attachment in one click.

I forgot how to record the steps in using macro in Outlook.

any macro gurus out there: HELP
 

More replies
Relevance 91.43%

Hi all,
I am new to macros, and am trying to create a macro that will automatically create an email, attach a file, and send the email to a specific address each time that Outlook is started.
I have tried the point and click method and have not been successful.
I would be very grateful if one of you gurus could give me a hand.
Thanks, Dale
 

Answer:Macro on Outlook 2002

Hi buddy, try this website:
http://www.asent.com/email_white_paper.htm
 

5 more replies
Relevance 91.43%

I've built a couple of macros in Outlook that I can invoke by clicking a menu item on the the menu bar. Currently, I need to baby-sit their installation if I want to put it on another machine. Is there a way to do this using a package and deployment process or something like that?
 

More replies
Relevance 91.43%

Hi,

I know I can create a mail merge in outlook (though have not done it yet!)

What I want to do is create a mail merge that uses names from a file instead of contact list and then attaches a different attachment based on contact name.

Is there a way to do this?

Thanks!!
Lori
 

Answer:Outlook Macro with add attachments?

Hi Lori

When you say "I know I can create a mail merge in outlook" do you really mean you can create a mail merge in Word using your Outlook contacts?

If so, you can use names stored in an excel file instead of the Contacts. You can then build a macro in excel to attach different attachments so long as there is some logic to what attachment will go with which name. The macro can then create and send the mails with attachments automatically.
 

3 more replies
Relevance 91.43%

Hi,

I wrote a outlook macro in VBA to ftp the files and send a notification mail after ftp.
Could u please any one help me to send the notification mail if the ftp got success alone.

Here is my code which will get the files from mail, change the name and save in a path, then ftp the files and send the mail of notification.


Private Sub Application_NewMail()

Dim ns As NameSpace
Dim Inbox As MAPIFolder
Dim Item As Object
Dim DT As Date
Dim Atmt As Attachment
Dim FileName(0 To 10) As String
Dim name_file(0 To 10) As String
Dim i As Integer
Dim n As Integer

'Processed
Dim j As Integer
Dim moveToFolder As MAPIFolder

'FTP
Dim FTPServ As String
Dim fNum As Long
Dim path As String
Dim File As String
Dim counts As Long

'executable
Dim batFileHandle As Integer

path = "D:\SUGANYA"
FTPServ = "204.254.175.102"

Set ns = GetNamespace("MAPI")
Set Inbox = ns.GetDefaultFolder(olFolderInbox)
Set moveToFolder = ns.Folders("[email protected]").Folders("Inbox").Folders("Processed")
i = 0

If Inbox.Items.count = 0 Then
MsgBox "There are no messages in the Inbox.", vbInformation, _
"Nothing Found"
Exit Sub
End If

For Each Item In Inbox.Items
j = 0
... Read more

Answer:Microsoft Outlook VBA Macro

Hi, You are trying to create a BATCH fle in DOS to do the FTP process. It is difficult to find the return status in this method.
Try to search on how to FTP a file directly in VBA using any available options or WIndows API Functions.
 

3 more replies
Relevance 90.2%

I would like an outlook macro to check for some part of the subject whether or not it exists in one of the already existing excel sheet and then if that part of the subject exists in one of the columns of that existing excel sheet then it should update another new excel sheet with the subject and body for that some part of the subject.For example,If the subject contains some text as "123Q" then it should look for this "123Q" in the already existing excel sheet and then if this exists in that excel sheet then it should update a new excel sheet with the subject containing "123Q" and its body.And if it doesn't exists then it should just show some message that the code you are looking for doesn't exists.Can anyone please help me on this one....Thanks a lot in advance.

Answer:Run Outlook Macro For Received Emails.

Please help me on this people.

7 more replies
Relevance 90.2%

Hi

I want to be able to correctly number the bulletin sent out. I need a macro that will look at the last one sent and increment the number by one. The number is currently four digits and when I introduce the macro it needs to use the next available.

The bulletin is sent by other staff, not just myself, so needs to be stored in the common folder. It is always sent from the same address/mailbox.

Thanks
 

Answer:Outlook 2013 Macro in header

Hi, I don't have the code for you but I can explain the way I would approach this.
If the mailbox that from which these bulletins are sent is the same I assume you have it as shared mailbox within your own account.
You would need a macro that checks the sent mail in that particular mailbox and reads the subject line (I image the bulletin number is in this section too)
Then calculate the max value and increment the found max value + 1 for the new bulletin.
 

1 more replies
Relevance 90.2%

Can anyone help me figure out a macro for Outlook 2007 that will adjust the zoom level when a user opens a mail item?
 

More replies
Relevance 90.2%

Hi, any VB gurus know how to get this script to work automatically each time I compose new, reply, and forward messages in Outlook 2003? I know this is not necessarily the Outlook forum but I know there are more macro masters in here!

Code:
Public Sub MyMacro()
Dim Mail as Outlook.MailItem

Set Mail=Application.ActiveInspector.CurrentItem
Mail.BCC = "your address here"
End sub
As it is now this will run but only when I go to tools, macros, run, etc. too tedious.

Thanks.
 

Answer:Outlook 2003 Auto BCC macro

Bump - can this not be done?
 

1 more replies
Relevance 90.2%

Hello,

I need to come up with an outlook macro using vbscript that runs whenever a new email meeting certain criteria is received.
Then after I want to update an excel sheet with some part of the data of the email received.
For example :-

1.A new Email with subject as "EXAMPLE".
2.Outlook then should run this vbscript macro so as to update that excel sheet with some part of the content of the email.
As I am a beginner not having enough knowledge on vbscript please help me out on this one.

Thanka a lot in advance any help appreciated.
 

Answer:Run Outlook Macro For Received Emails.

16 more replies
Relevance 90.2%

Hi Guys,

I am a noob with outlook macro and been toiling around the internet helplessly for some assistance on a macro.

I am looking for a macro in outlook 2010, which will get automatically trigger whenever an email is being reply by a user with a shared mailbox. The macro will perform the below steps

1.“Lock” the email so that other users is not able to reply to the email
2.Scan subject header for a unique reference in the format of CASEDDMMMYYHHMMSSXXX
- Where “CASE” is fixed
- “DDMMMYY” follow the date format - DD and YY in number and MMM in aphabet
- “HHMMSS” follow the 24 hour time format
- “XXX” denote the number of character on the original subject header
3.If this reference is available, no changes is required. Original email will be moved to a preset folder after email is sent
4.If this reference is not available, append the unique reference at the end of the subject header*. Original email with new subject header will be moved to a preset folder after email is sent

*for example, if the original email subject is “URGENT – Need your Response ASAP”, the macro will change the subject header to “URGENT – Need your Response ASAP – CASE01FEB13223763032”

Appreciate any help i can get!

PS - I got some help with the partial code and i would appreciate any help with the full code!

If Not .Subject Like "*CASE##???###########"Then
.Subject =.Subject & " - CASE" & Format(Now, "DDMMMYYhhmmss")& Format(Len(.Sub... Read more

More replies
Relevance 90.2%

I was just asked this week by one of my clients that are running exchange 6.5.7638.1 that they have some employees running a macro that enables them to input dates on their emails and some employees that do not. My question, is this a macro that is input through exchange or through outlook on the client level.

thanks in advance, I have been digging around for an answer.
 

Answer:Outlook or exchange macro question

Hi, I'm no Outlook expert but I do know you can design your own mail templates and include options when you use one.
Probably some vba code too but the basics is the mail templates.

Hope this information may help finding specific examples, Have you tried Google search for Mail templates in Outllok or similar?
 

1 more replies
Relevance 90.2%

What I'd like is a macro or rule that when I hit a key or add the option to the right click menu in Outlook would auto reply with an email telling the emailer their message was deleted, not read and please unsubscribe. Then do that - move the email to the deleted items. I know I can right click and do a quick rule, but then I have to select the destination, bla bla bla.. it has to be able to be done quickly with a reply to the sender.
Any Outlook gurus got this?
 

More replies
Relevance 90.2%

I had a macro in Outlook XP that entered a certain amount of text and formatted it.  We use it in most of our emails and immediately run it when creating a new email.  It worked fine.  (For what it is worth, I copied it into a Word 2007 macro and it worked fine there also).I cannot figure out to create this macro in Outlook 2007.  I went to trust center and enabled all macros with no security at all.I went to Tools, Macros, Visual Basic Editor.  In the top left box I created a new module and pasted in the text of the macro.  But now I cannot figure out how to run it in a new email.  In a newly created macro there is no tool option to call up a macro.I try to run it within the visual basic editor, but I get an error message that says macros in this project are disabled and refers me to online help for how to enable macros.How do I create a macro that I can run upon opening a new email that is to be sent?If it matters at all, the text in the macro is:Sub EmailProtocol()'' EmailProtocol Macro' Macro recorded 8/22/2006 by Gisele Prive'    Selection.InsertDateTime DateTimeFormat:="d-MMM-yy", InsertAsField:=False, _         DateLanguage:=wdEnglishUS, CalendarType:=wdCalendarWestern, _        InsertAsFullWidth:=False    Selection.TypeText Text:="  "    Selection.InsertDateTime DateTimeFormat:="HH:mm", InsertAsField:=Fals... Read more

More replies
Relevance 90.2%

Hi,

I am an extremely basic user who has managed to get a basic macro together through multiple web searches and am now stuck...

I have dates entered into the following columns in excel: 14,15,16,26,27,28

I have managed to make the macro create appointments for 14,15,16 but not the rest. Also, every time i run the macro it creates a new appointment regardless if one already exists. I saw on this forum about adding a word to another column which the macro searches for and if found doesnt create a new appointment - or something to that extent. Here is what i have:

Sub POATEST()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")

' Start at row 7
r = 7

Do Until Trim(Cells(r, 1).Value) = ""
For Each cell In Range(Cells(r, 14), Cells(r, 16))
If cell.Value <> "" Or 0 Then

' Create the AppointmentItem
Set myApt = myOutlook.createitem(1)

' Set the appointment properties
myApt.Subject = Cells(r, 1).Value & " " & "Update Due"
myApt.Start = cell.Value
myApt.categories = "Yellow Category"
myApt.ReminderSet = True
myApt.Body = "blah blah blah"
myApt.Save
End If
Next cell
r = r + 1
Loop
End Sub

Please can someone assist by:
1. making it apply for all the columns originally mentioned
2. making it search if an appointment for that item (ie that row) exists - if not, create appt, if so, do not create appt and insert "Yes" in column 29

Thank... Read more

Answer:Excel Macro - Add Appointment To Outlook

HI,

Check this code you may be able to modify it.
Have not used it in a long time but....

Code:

Sub AddAppointmentsToCalendar()
Dim OLF As Outlook.MAPIFolder, objItem As Outlook.AppointmentItem
Dim i As Long, lngItemCount As Long, r As Long
On Error Resume Next
Set OLF = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderCalendar)
On Error GoTo 0
If OLF Is Nothing Then Exit Sub

Application.StatusBar = "Adding appointments to Outlook..."
With wsSheet1
.Activate
r = Range("NewAppointments").Row + 1
Do While Len(Range("A" & r).Formula) > 0
On Error Resume Next
Set objItem = OLF.Items.Add(olAppointmentItem)
On Error GoTo 0
If Not objItem Is Nothing Then
With objItem
.Start = Range("A" & r).Value
.End = Range("B" & r).Value
.Subject = Range("C" & r).Value
.Body = Range("D" & r).Value
.Categories = Range("E" & r).Value
.ReminderSet = False
.Save
End With
Set objItem = Nothing
End If
r = r + 1
Loop
End With
Application.StatusBar = False
Sheets("Appointments").Select
Range(&... Read more

1 more replies
Relevance 90.2%

I have been battling with Microsoft Outlook 2003 for a while now.

The Problem:
I have created several macros (they all accomplish the same thing) and every time I make a button for the macro and add it to the toolbar it disappears after an Outlook restart. I originally only had two buttons that i created which actually have stayed like they should. Any new buttons disappear as described above. The macros remain but the buttons disappear!

Background:
I have created a few macros to add text into the subject line. This text includes a one time manual entry into the code as well as the macro grabbing the date and putting it into a specific format before adding it to the subject line. The code can be seen below:

Sub XXX()
On Error Resume Next
Set msg = ActiveDocument.MailEnvelope.Item.GetInspector.CurrentItem
Today = Format(Now(), "yymmdd")
If Not msg Is Nothing Then
msg.Subject = "XXX " & Today + " - " + msg.Subject
End If
msg.Subject = Nothing
End Sub

-This is run on MS Outlook 2003 (using MS Word 2003 as the editor, so it is technically a Word macro).
-Windows XP OS

Things I have tried:
I have tried using the /a switch (which sometimes runs a utility I was told)... didn't work.
I have edited Normal.dot... didn't work
I have deleted Normal.dot and allowed a new one to be created... didn't work
I have repeated the two above but doing it to Email.dot
I have played with the code to see if that changed anything... didn't wor... Read more

Answer:Outlook 2003 macro disappearing

Hi blcsoccer16
Welcome to Tech Support Guy Forums!

Since this is a work computer and not your personal computer, you will need to speak with your IT department.

Closing thread.
 

1 more replies
Relevance 90.2%

Hi, I need a little help with Outlook 2003, I have alot of
Drafts, which I just replace the name and date, then send
the email to multiple people multiple days, and was
wondering if there is any way to do some sort of auto date
so the date changes to the current date, any help would be
very apprechited, thanks.
 

Answer:MS Outlook 2003 Macro Questions

If you ever have a question about Word macros or Excel macros, then hopefully I can help you right here in Tech Support Guy.

However, for questions about programming in Outlook, you might want to try the following link, which is specific to writing macros in Outlook. (things don't get more narrowed-down than that, do they? )

my recommendation:

http://www.vbaexpress.com/forum/forumdisplay.php?f=18

or, in case the site has moved (I doubt it), then try the following google search:

http://www.google.com/search?q="forum+outlook+help"
I'm sorry I can't personally be more of a help. As I said, I'll be glad to help when it's a Word question!!

Best of luck to you,
-Kelly
Kelly's Humble Macro Page
 

1 more replies
Relevance 90.2%

Hello,
First off what a knowledgeable and useful site you have. I have been trying to sort out several IT issues now that I have become my organisations IT guy i.e. I can fix a few software and hardware issue without calling in tech support. However my Outlook Macro skills have been found wanting so by searching this site I found this old closed thread

http://forums.techguy.org/business-applications/867198-date-macro-outlook-2003-a.html

which is exactly what I was looking for, to Rollin_Again for his great advice, on how to get the date inserted automatically into outlook 2003 subject line when I open an email using the date time group of yyyyMMdd. I'm using his recommended code:

Sub CreateMail()

Dim objOutlookMsg As Outlook.MailItem
Set objOutlookMsg = Application.CreateItem(olMailItem)
objOutlookMsg.Subject = Year(Date) & Month(Date) & Day(Date) & " - TEST SUBJECT"
objOutlookMsg.Display

End Sub

And I have the macro set up and working.

The only problem is that instead of displaying the date time group as yyyyMMdd so that for 1 Feb 2010 it would read 20100201 it will display it without the month and date with a preceding zero such as 201021. I've searched this site and goggled for the last 4 days to try and sort the issue out myself but no luck hence the post here. I have changed my regional settings in the control panel trying out other date formats and customising my own, they replicate through to word and excel but I just can't... Read more

More replies
Relevance 90.2%

Hi everyone,

I know absolutely nothing about VBscript(my srengths lie elsewhere...). So I recently copied a macro script which would enable automatic printing of every email I send from Outlook 2k. The macro works 100% fine but there is one slight problem. It first prints the message, THEN sends it. This results in the printed report not showing me vital information, such as to whom it was sent, date, time etc. How can I modify the code to FIRST send the message, and only print it once it lands in the Sent Items folder? Printing an email from this folder shows the info I need on the printout. Any ideas?

Thanx
Brunette
 

More replies
Relevance 90.2%

Hi there,

I am trying to get a macro for Outlook 2003 that when I compose a new email in Outlook 2003, the date will appear in the subject line automatically in the following format:
20101009-
I have tried looking into it in Outlook but it says that macros will not work in Outlook and I have to do in in VB Editor. Unfortunately I am a complete novice (or noob as my son would call me) with VB Editor.
Would anyone be able to help me out please?
 

Answer:Date Macro for Outlook 2003

10 more replies
Relevance 90.2%

Hi All
I'm continually doing the same thing in Outlook 2013 when journaling my emails.
1. Go to Sent Items
2. Click on email to Journal
3. Drop Down Move icon and choose 'Journal'
4. Click File tab and choose 'Save As'
5. Click on folder called Clients
6. click 'Save' button.

I would be doing this 100's of times a week. Could someone please help me write a Visual Basic macro to do this for me.
I have set up the developer tab and can name a macro, but it doesn't look as though you can 'record' a macro like you could do in excel. It looks as though you need to be able to write the whole thing from scratch. This makes it very difficult for newbies like me to at least have a go and then only ask genius like you when I get stuck.
Thanks for your help.
David.
 

More replies
Relevance 90.2%

I'm looking for instructions on how to create a macro is Microsoft Office 2003 that will save an attachment to a specific file path, with a specific file name upon reciept of the email from a specific individual and/or with a specific message subject. Is this feasible?
 

Answer:Outlook Macro to process attachments

Take a look at the solution I posted here to see if this is similar to what you need.

http://forums.techguy.org/business-applications/972897-solved-outlook-2003-automatically-save.html

Regards,
Rollin
 

1 more replies
Relevance 90.2%

Hello! I have this macro assigned to a custom button so I would faster copy an email in to the clipboard, but the thing is, it makes a copy to the whole e-mail even when there are reply's in it, but what I need is that this macro makes a copy from the last reply and not more. Could someone please help me to advance the code below.

Code:
Sub CopyMessageToClipboard()
Dim objSelectedItems As Outlook.Selection, _
objItem As MailItem, _
strBuffer As String, _
objData As New DataObject
Set objSelectedItems = Application.ActiveExplorer.Selection
For Each objItem In objSelectedItems
If objItem.Class = olMail Then
strBuffer = "From: " & objItem.SenderEmailAddress & _
vbCrLf & "To: " & objItem.To & _
vbCrLf & "Sent: " & objItem.SentOn & _
vbCrLf & "Subject: " & objItem.Subject & _
vbCrLf & "Body: " & objItem.Body
objData.SetText strBuffer
objData.PutInClipboard
End If
Next
Set objItem = Nothing
Set objSelectedItems = Nothing
Set objData = Nothing
End Sub

 

Answer:MS Outlook 2003 copy macro

Are each of the replies seperated by the phrase "-----Original Message-----" or something similar? If so you just need to set a variable equal to the message body and then use the left or mid function in VBA to seperate the last response.

Can you post a sample email?

Rollin
 

3 more replies
Relevance 90.2%

Is there a way to create a macro in Outlook that will minimize Outlook before closing?
 

Answer:Outlook Macro -> Minimize Before Closing

16 more replies
Relevance 89.38%

Moved from Software Development
Hi, We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in to emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed so they could be updated by all. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I have updated an excel spreadsheet containing all the information and I would like to create a macro for all the team to periodicaly import this data in to Outlook Contacts and possibly create distribution lists from these. I trust this makes sense I am using Outlook 2003.
Thanks
 

More replies
Relevance 89.38%

Hi Team,I want to delete the Outlook messages which has Subject "Out of Office:", with help of VBA Macro.Thanks in AdvanceVenku

Answer:out of office: mails delete outlook macro

http://www.bing.com/search?q=outloo...How To Ask Questions The Smart Way

2 more replies
Relevance 89.38%

I'm looking for a macro that takes me to the 'Advanced Find' function (Ctrl+Shift+F) in Outlook, then to its advanced tab. Also need the field section to auto select 'Subject,' switch condition to 'Contains,' and, this is where I feel I'm pushing it, auto-fill the 'Value' with the subject of the currently selected email.

Any help would be appreciated. Thanks.
 

More replies
Relevance 89.38%

hey guys, i'm using Outlook 2003 and the macros are disabled. does anyone know which registry keys can be altered or created in order to enable macros?
 

Answer:Outlook 2003 macro registry keys

You shouldn't have to mess with the registry. Do you get a security warning when you try to create a macro? You may have to lower your macro security settings to allow them to run. Otherwise, maybe that feature wasn't installed when you installed Office?
 

6 more replies
Relevance 89.38%

Hi All

Please can I ask someone familiar with writing Macros for a little help please? I would like to be able to use a keyboard shortcut (say Ctrl+L) to write the word 'Leasehold' in the body of an email.

I do not have the faintest idea of how to write a Macro, I can do one in Word, but that is designed to be very easy anyway.

Thank you in advance
 

Answer:Macro for writing text in Outlook 2007

Without needing a macro, you could use AutoCorrect to do this for you. In Outlook, open a new email and go to the Office Button, and then Editor Options (I think. I have 2010, so I'm bringing this part up from memory) You may have to go to Options and then click on Editor Options. In the Editor Options window go to Proofing and click on AutoCorrect Options. You can add an entry along the lines of Replace l* with Leasehold and it should correct that for you. Let me know if that works for you!
 

5 more replies
Relevance 89.38%

Hi all,

I'm looking to create an Excel document and I need to put cells with dates in that are linked to outlook calendar reminders.

I.e I need a macro that when I click the link it sets the reminder on outlook for the date allocated in the cell.

could anyone please help me with this as i have never created a macro and would greatly appreciate any help you could give me.

Thanks

More replies
Relevance 89.38%

While looking for a way to save embedded (as opposed to attached) pictures in Outlook, I came across this site: http://www.howto-outlook.com/howto/saveembeddedpictures.htm

The link goes to a set of instructions on how to create the macro that will save all embedded pictures in an Outlook email message. (The site owner is a Microsoft MVP for Office Systems ? Outlook, is MCSA + MCSE certified for Windows 2000 and has been working professionally with Exchange and Outlook systems since 1999.)

According to the site, "The code has been tested with Outlook 2003 on Windows XP and Outlook 2007 on Windows Vista but should work on previous versions as well." I did the instructions, and it worked for me on Outlook 2007, Windows 7 64 bit system.

While Microsoft figures out a way to do it easier than copy each picture > paste into Paint > save as a ".bmp", this should help.

Answer:VB Macro for Saving Outlook Embedded Pictures

I love that site Visit there often

2 more replies
Relevance 89.38%

Hi all.

Is possible to do this avoiding the use of the application_startup event (occassionaly it doesn't works)?

I've read the /autorun switch isn't available for outlook 2007.

Thanks in advance.
 

More replies
Relevance 89.38%

Hi,

I would like to create a macro that creates a rule to delete emails from the sending domain.

The idea is that you're looking at spam from a domain and you want to create a rule to prevent all future emails from that domain.

Not sure if this is hard or easy to do.

Thanks!

Answer:Outlook button macro to create rule

Hi, not really the forum for this:-

How to Create Email Blacklists in Outlook | eHow.com

1 more replies
Relevance 89.38%

hey guys, i need a macro or script created for Outlook 2003 to make things a bit easier/quicker at work.

we remotely monitor equipment in the field, and each piece of equipment has its own I.D. number.....when one of those pieces of equipment goes offline (or reports any number of other errors), it sends us an email, and the same thing happens when it comes back online. we have a seperate folder that each of these different types of errors gets sorted to automatically.

what i want to be able to do is manually run a macro or script on the emails in any specific folder that i choose, which will compare the time/date the error was recorded against the time/date the error cleared, and if the cleared is newer than the recorded, it will delete them both.

i have included a partial screenshot of the subject lines of one of these folders as a visual reference to what i'm talking about (with non-essential company-specific information blacked out, of course):

it doesn't necessarily need to be written so that it compares specific words in each email's subject line, as long as it compares subject lines that are identical to each other, with the exception of the words "recorded" and "cleared"...and as i mentioned before, it needs to be written so that i can choose which folder (or folders) to run it in. it must not be written to run automatically, it has to be ran manually, so we do not accidentally miss something that we need to see.

i have no way... Read more

Answer:Outlook 2003 script/macro needed

not quite sure, but this site might be a good place to start looking.
 

3 more replies
Relevance 89.38%

Hi Guys,

I'm setting up a new system for some of our users, and the long and the short of it is I want them to set flags on the outgoing mail so that when it reaches it's destination, rules on the inbox can use the flag to filter the mail into relevant folders.

For instance, in one example a user may create a new message, fill in the address, subject and body and then click on the 'message flag' icon on the toolbar, overwrite the 'Follow up' string with say 'For Canterbury' and then send their mail. When the mail reaches it's destination a rule reads the 'For Cantebury' flag and moves it into a relevant folder.

Now it all works fine, but the system is set to be expanded, and if possible I'd like to have a toolbar when a user creates a new e-mail, that has buttons relating to all the possible flags, they press the relevant button, and hey pretso the flag is set.

I tried recording a new macro, going through the process above, but none of the actions were recorded, if I had the vba script, I could easily amend it for all the given flags, and create a toolbar, saving them time, and me headaches as they're bound to make typos and the like if they manually have to type the flags.

So can this be done? If so, anyone know how? Or if not, can anyone think of another way of acheiving this?

Hope all that makes sense, and many thanks for any help you're able to offer me.

Nick
 

More replies
Relevance 89.38%

Hello
I would appreciate if any of you could tell me how I could write a macro that was launched whenever the from field of a new email message window under Outlook 2007 is populated with a particular email address [email protected] from the list of available email addresses.
Thanks
 

More replies
Relevance 89.38%

I need a macro that will 1) create a new outlook folder, then 2) create new Outlook distribution lists from data in an Excel sheet.

The Excel sheet has columns:
A - ID
B - DEPARTMENT_DESC
C - STUDENT_LEVEL_DESC
D - MAJOR_DESC
E - PROGRAM_DESC
F - EMAIL_ADDRESS
G - LAST_NAME
H - FIRST_NAME

The first entry begins in row 2 with row 1 being the column title.

I need a new distribution list to be created for each department (column B) and each student level (column C). (Column B will only ever be one of 6 values, column C will only ever be one of 2 values. Therefore, the macro should create 8 distribution lists.)

I have looked at threads similar to this question but I can't seem to get anything working.
 

Answer:Macro from Excel to New Outlook Distribution List

I saw something you might could work with here: http://www.helenfeddema.com/CodeSamples.htm
scroll down for sample 61. I haven't used it but marked it one day. I'm assuming your wanting to make local distb list? Not in AD.
 

1 more replies
Relevance 89.38%

Hi,

I'm trying to program a macro under Outlook 2003 to perform the following actions:
-check a shared mail folder
-move mails from a certain sender with a certain subject to another shared folder
-save the attachments onto a fisical hard drive
-edit the text of the email inserting a note like "the attachment was moved to C:\Archive"

Is this possible?

Thank you for any help

luigimaria
 

Answer:Outlook 2003 macro actions issue

Almost done, I just don't know how to access the shared email folder instead of my inbox!
Any suggestion?

Thanks
 

1 more replies
Relevance 89.38%

Hi

This is a tuffy........

I want a macro so that when i type a message into a cell it will put it into outlook as a reminder, or even a simple macro button that opens outlook in the scheduler.

Any ideas?

Thanks
 

Answer:Excel macro links to Outlook Reminder

Try this link.
 

1 more replies
Relevance 88.15%

Hi im new to using outlook but i do have some programing experience, what i want to do is that whenever i close an email message i want this macro to run, but i dont know how to do this, and if that is possible, is there a way to make this macro run only on the first time i read the mail?

please help

I'm trying to use WithEvents to get the closing mailItem event to trigger my macro, i found this code off the internet for getting the mailitem but i cant seem to get it to work, help plzzz

Dim WithEvents vInspectors As Outlook.Inspectors
Dim WithEvents vExplorers As Outlook.Explorers
Dim WithEvents vExplorer As Outlook.Explorer
Dim WithEvents vMailItem As Outlook.MailItem

'I use the following code to get the vMailItem variable set:
Private Sub Class_Initialize()
Set vInspectors = Application.Inspectors
Set vExplorers = Application.Explorers
If Not ActiveExplorer Is Nothing Then
Set vExplorer = ActiveExplorer
If TypeName(vExplorer.Selection.Item(1)) = "MailItem" Then
Set vMailItem = vExplorer.Selection.Item(1)
End If
End If
End Sub
Private Sub Class_Terminate()
Set vInspectors = Nothing
Set vExplorer = Nothing
Set vExplorers = Nothing
Set vMailItem = Nothing
End Sub
Private Sub vExplorer_SelectionChange()
If vExplorer.Selection.Count = 1 And TypeName(vExplorer.Selection.Item(1)) = _
"MailItem" Then Set vMailItem = vExplorer.Selection.Item(1)
End Sub
Private Sub vExplorers_NewExplorer(ByVal Explorer As Explorer)
Set vExplorer = Explorer
If TypeNa... Read more

More replies
Relevance 88.15%

In Outlook 2007, I often receive e-mail responses from people where the line spacing in their message (and in my original e-mail to which they are responding) has been set to Auto, which looks like double-spaced text.I hate going through the trail of attached e-mails changing the line spacing back to get rid of the extra space, but not doing it means that I must do a lot more scrolling to see what I'm responding to.I wanted to create a simple macro for changing the line spacing of the selected text, but Outlook has no "macro record" button! So I had to write one. In order to do this, I recorded the same macro in Word, then copied the macro code to a new macro in Outlook. But when I run it, it doesn't work at all. I get an error message: "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros."Previously I had a different error. I used the following code: With Selection.ParagraphFormat .SpaceBefore = 0 .SpaceBeforeAuto = False .SpaceAfter = 0 .SpaceAfterAuto = False .LineSpacingRule = wdLineSpaceSingle End WithAnd I had an error that "Selection" was not defined (or something like that).What do I need to do to get this to work?T

Answer:How do I create a line spacing macro for Outlook messages?

Have you tried changing the macro settings to Enabled?

3 more replies
Relevance 88.15%

Hi there!

So I've found the code below here: http://www.google.com/support/forum/p/Calendar/thread?tid=5e4909ca64cffe90&hl=en - Full credit goes to user 'tpuiatti'

Code:
Sub Generate_ICS()
Dim rng1 As Range, X, i As Long, v As Long
Dim objFSO, objFile
Dim FilePath As String
FilePath = "G:\Service.ics"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile(FilePath)
Set rng1 = Range([a5], Cells(Rows.Count, "H").End(xlUp))
X = rng1

objFile.write "BEGIN:VCALENDAR" & vbCrLf
For i = 1 To UBound(X, 1)
objFile.write "BEGIN:VEVENT" & vbCrLf & "DTSTART:" & Format(X(i, 2), "yyyymmdd") & vbCrLf & "DTEND:" & Format(X(i, 2), "yyyymmdd") & vbCrLf & "RRULE:FREQ=YEARLY" & _
vbCrLf & "SUMMARY:" & X(i, 1) & vbCrLf & "END:VEVENT" & vbCrLf
Next i
objFile.write "END:VCALENDAR"
End Sub

This code takes the info from 2 columns in Excel: A which is the event title and B which is the event date. Then it export these informations to an .ics file which will add the event dates to the Oulook Calendar.

The macro and the .ics work perfectly, however i wan't to make a few changes/additions to fit my needs. Additionally I wan't this macro to:

- Pick up dates from column &... Read more

Answer:Additional code to Excel macro - export to Outlook

7 more replies
Relevance 88.15%

Good Morning,

I have very limited knowledge when it comes to Macros and VBA.

What I need is one of two possible scenarios.

1. Information from a Training Assignment PivotTable exported to a shared calendar on Outlook.
2. Information from a Training Calendar bulit as a Macro in Excel exported to a shared calendar on Outlook and the ability to update either calendar if new information becomes available.

Don't know which is best using code via VBA or using the Export/Import functions.

Any help is greatly appreciated
 

More replies
Relevance 88.15%

I have a Contact form in my Personal Forms Library and the name of it is "Contact Form 1" And in the form, there are the commandbuttons and date fields that have all the areas of creating a Calendar Event for the contact I open and put in all the information in those fields, and then I have commandbutton that when I click it, it creates the Calendar event.
So here is the code in the Contact form script area that does it in the form of the Contact that I use.....however, I would like a macro that when I select a Contact but now open it, it automatically clicks on the commandbutton that creates the Calender Event....so to me, it is a macro that runs the script code that is in the Contact....so is there a macro for Outlook 2007 that can run a script code from the contact I select but not open?
That would great and thanks so much!!
Code:
Sub btnAddCalendarEvent_Click
dim ContactName
dim olns
dim MyFolder
dim NumItems
dim myItems
Dim StartDateTime
Dim EndDateTime
Dim ShowAs
Dim itmAppt
ContactName = Item.GetInspector.ModifiedFormPages("General").Controls("Fullname").value
Set olns = Item.Application.GetNameSpace("MAPI")
Set myfolder = Session.GetDefaultFolder(9).Folders(2)
Set itmAppt = myfolder.Items.Add("IPM.Appointment.Office Calendar Event")
itmAppt.Subject = ContactName & " - " & item.getinspector.modifiedformpages("General").controls("combobox11").text
itmAppt.Location = ... Read more

Answer:Outlook 2007 Macro to Run a Script From a Contact Selected

Any update from someone today maybe??
 

2 more replies