MS Project 2013 – Macro to automate emails

MS Project 2013 – Macro to automate emails to PM’s or Stakeholders at Milestones

If you have a need to automate emails based on certain requirements being met, I.E., you have reached a certain level of completion for that task or you have reached a milestone, then this is the script for you. It creates emails either on open or change and you can customize it to include information from your project plan. Its pretty self-explanatory and an easy script to follow. Right now it is set to display the emails that are auto generated so the user can see each one before its sent, but you can easily change that to automatically send by changing the mail.display line to mail.send if you’d like.

Use and enjoy!

Call the script

Private Sub Project_Open(ByVal pj As Project)
Call emailtrigger
End Sub

Script Code

Sub emailtrigger()
Dim tsk As Task
Dim succ As Task
Dim ol As Outlook.Application
Dim mail As Outlook.MailItem
Dim current As Variant
Dim previous As Variant
Dim days As Integer

For Each tsk In ActiveProject.Tasks
If tsk.PercentComplete = 60 And tsk.ResourceNames <> “” Then
If ol Is Nothing Then
Set ol = CreateObject(“Outlook.Application”)
End If

Set mail = ol.CreateItem(olMailItem)
mail.To = tsk.ResourceNames
mail.Subject = “Project EIT-TOM P0507799 – ” & tsk.Name & ” has reached 60% complete”
mail.Body = “PROJECT: Project EIT-TOM P0507799 ” & vbCrLf & “TASK: ” & tsk.Name & vbCrLf & “MILESTONE: Percent completed hits 60%.” & vbCrLf & “PROCESS GROUP: ” & tsk.Text1 & vbCrLf & “WORKSTREAM: ” & tsk.Text4

End If
Next tsk

For Each tsk In ActiveProject.Tasks

current = Format(Now, “MM-DD-yyyy”)
previous = Format(tsk.Finish, “MM-DD-yyyy”)
days = DateDiff(“d”, CDate(current), CDate(previous))

If days = 60 And tsk.PercentComplete <> 100 And tsk.ResourceNames <> “” Then

If ol Is Nothing Then
Set ol = CreateObject(“Outlook.Application”)
End If

Set mail = ol.CreateItem(olMailItem)
mail.To = tsk.ResourceNames
mail.Subject = “Project EIT-TOM P0507799 – Finish date is less than 60 days for task – ” & tsk.Name

mail.Body = “Project EIT-TOM P0507799 – ” & vbCrLf & “Task Name – ” & tsk.Name & ” – Finish date is less than 60 days.” & vbCrLf & “Process group -” & tsk.Text1 & vbCrLf & ” Workstream – ” & tsk.Text4


End If

Next tsk

End Sub

50 Food Icons

food drink icon set

This freebie is a set of 50 vector food icons in PSD format. Easily scalable vector illustrations suitable for restaurant and bar websites, apps and more. File resolution is 1280 x 1024. This freebie is brought to you by our friends at PSDblast.


50 food icons

PerfectKit – Free Web And Mobile UI Kit

Friends, today’s freebie is a free version of PerfectKit. It’s a UI pack containing 20 well-organized UI elements in layered PSD files. The full version is paid containing over 60 ready-to-use blocks and hundreds of elements. You can combine and customize them to create beautiful interfaces for your design projects endlessly. These are created by talented designer, Stelian Subotin.

Free UI Kit Elements PSD

File Format: .PSD
Layers: Vector, Smart-Layers
File Size: 46.9 MB

The post PerfectKit – Free Web And Mobile UI Kit appeared first on Free PSD, Graphic & Web Design Resources | GraphicsFuel.

The Advantages of Using Pre-Made Layouts over Wireframes

Even with a little expertise and the right tools, creating a wireframe rendition of a web page is still a time-consuming activity, and a complete wireframe can only emulate the real thing to a certain degree.

  1. A conceptual design must be in place before the wireframing can be initiated. A conceptual design is already embedded in a pre-made payout, and only needs to be edited.
  2. Design sketches have to be transferred onto a grid before a wireframe can be constructed. With a layout, once a grid is selected, the transfer is automatic, and sketches are unnecessary.
  3. An advanced website designer can construct a wireframe in a reasonably short time. A novice designer can build a working website page in a much shorter time, and often with superior results.

The bottom line: Pre-made layouts offer a much faster approach, and unlike a wireframe, they seamlessly evolve into a finished product.



Ice Cream


Web Design










Pre-made Layouts are Productivity Enhancers

Because a conceptual design is already in place, and since the steps involved in transforming a layout into a finished web page are almost always easier and faster than attempting to accomplish the same task using wireframing, your productivity is bound to increase. By switching over to using pre-made layouts, you can still take whatever time you feel you need to work specific details, but instead of fighting to meet a deadline, you will find that you have time to spare. Your clients will be pleased with the quick turnaround times you will be able to commit to.

It takes but a Click to Install One of Be Theme’s 130+ Premade Layouts


You could pick any of Be Theme’s 130+ pre-made layouts at random, and with a little editing create the exact user experience you are looking for. You will get off to a much faster start however by browsing the complete selection to find the best fit. This process is at least an order of magnitude faster than the time it takes to sketch out a preliminary design and construct a very basic wireframe model. With a layout, you already have your conceptual design, and you are ready to start page building.

The video demonstrates just how easy it is to get started. It takes but a little over a   minute to watch, and it shows you how rapidly you can take a layout, edit an image here, add content there, and change the location of a design element or two to produce a web page that may still need some polishing, but one that is nearly ready to be published.

You can’t build a page that quickly without the use of a pre-made layout to get you off to a fast start.

The reason is simple. The features and functions you need are either embedded in the layout or can be added or changed, a click at a time, during the page building process. The tools you have to work with, including an options or admin panel, make keeping track of your efforts a simple task. Be Theme keeps track for you. The net result is a web page, or an entire website, that is not only ready to be delivered to your client in a relatively short amount of time, but one that is equal or better in its quality of appearance and its functionality than most anything you have been able to produce in the past.

Customer Support – There if You Need It

Be Theme is delightfully easy and intuitive to use, and you may never have to contact customer support. As you learn more, and try different things however, you will most likely have a few questions. Some answers are in the User Manuals, the easy-to-follow Video Tutorials, or documented in the Forums, a place where users share their experiences. If you need to contact a real, live problem solver however, there will always be a support staff member who is ready and able to provide a prompt answer, solution, or recommendation. The Be Theme support staff is one of the best in the business, and it is one of the driving forces behind Be’s widespread popularity.


The Core Features

It may come as a bit of a surprise to discover that the 130+ premade layouts feature is not listed among Be’s two dozen Core Features. The reason for this is simple. These layouts stand alone. They are the main feature; the one that is most closely identified with Be Theme. The Base Grid and 17 Customizable Header Styles aren’t included either, but it’s these three features that more than anything that get your project off to a brisk start.


Be has every feature you are ever likely to us. To build web pages quickly and easily, you can select either Muffin Builder, which really shines when complex pages are needed, or Visual Composer, a long-time favorite of many web designers. You can try them both and see which one you like best. It may not be an easy decision to make.

Two other core features, the Muffin Options Panel and the Layouts Configurator make website building a nearly seamless activity, and add variety to you pages, respectively. Your website won’t look as if every page was created from the same template, giving you high marks for creativity.

Parallax effect and video and custom backgrounds, together with a shortcode generator, will take you far beyond what you can accomplished by wireframing. Visit the website to find out more what these, and the other 20 or so core features bring to the table. You will be impressed.



A Genuine Time Saver – From Day One

It bears repeating – take a few minutes to browse Be Theme’s website. If what has been shown here hasn’t yet convinced you of the benefits pre-made layouts present that wireframing does not, the information provided on the website certainly will. What you will discover the first time you put this premier WordPress theme to use, is that you will be able to create several high-quality web pages in the time it would normally take to sketch out a conceptual design and begin fabricating a basic wireframe model. You and your clients will definitely notice an uptick in your productivity.


The post The Advantages of Using Pre-Made Layouts over Wireframes appeared first on GraphicsFuel.

iPhone 6S Plus Vector Mockups

Friends,  today’s featured freebie is a set of iPhone 6S Plus vector mockups in PSD and Ai files. The mockups can be easily edited via smart-objects (PSD) to present your design stuff. The mockups come in front and angled view. The resource is created by Perfect Pixels. Download now!


File Format: .PSD, .Ai
Layers: Vectors & Smart-Layers
File Size: 16.4 MB

Free PSD Watercolor Backgrounds

Free PSD watercolor backgrounds that could add a fresh and colorful feel to your designs. They can be used for various web projects. Don’t hesitate and grab this awesome freebie now!


Free PSD watercolor backgrounds in made high resolution for a colorful look and feel. Use this set to liven up your designs.

These 10 pieces of watercolor illustrations are suitable for a website backgrounds, collages, publications, business cards and many more.

The downloadable archive contains psd files, which you can edit with Adobe Photoshop CC. Each one is fully layered, grouped and properly named for your convenience. That way you will have no trouble customizing them as you wish with just a few clicks.

If you need more backgrounds and textures for your web or print projects, be sure to check out our Backgrounds and Textures section and take your pick.

Download our free psd watercolor backgrounds now by clicking on the Free Download button below!

Free PSD Watercolor Backgrounds

Free PSD Watercolor Backgrounds

Resolution: 1900×1405 px
File Format: PSD
File Size: 162 MB
Number of Items in Set: 10
Author: Free PSD Files

Note that if you want to spread the word about our freebie, you need to link back to this post. Links to download page or download archive are not allowed.

The post Free PSD Watercolor Backgrounds appeared first on Free PSD Files. Launched

Friends, today I am really happy to announce the official launch of my new design blog,  Braaanding had been in development for quit some time and I worked really hard to make it happen.

So what’s Braaanding all about. Its a niche design blog featuring best of the branding and packaging designs from around the world.

Ever since I started my career as a designer, I was smitten by the beauty and creativity of various national and international brands, prints and packages designed by the creative designers.  I always thought to start working in that area at least for a few days a month, but that never happened as I have always been busy with the web and mobile design works. But that didn’t stopped my spark of love for the branding industry, so I tried to start at least something that can feed my passion for it – and here comes Braaanding – of course after a long time. :)

Braaanding is a blog showcasing leading branding, packaging, print designs to help graphic designers who go on every day to the internet to search and seek inspiration for their print media design work.

Braaanding is a dedicated platform for graphic designers, print designers, conceptual artists, advertising agencies, students, and every person who’s interested in best branding and packaging designs. I have categorized the showcase in several different categories such as Alcoholic Beverages, Beauty, Books & Media, Fashion, Food & Drink, Health Care, Kids & Baby, Office & Art Supplies, Pets, Snacks & Desserts, Sports, Technology, Toys & Games and Vintage.

I also encourage designers and agencies to submit your work and get exposure to their creative work and at the same time inspire other designers.

I request all my dear readers to share the site in your social circles and follow it and encourage others to follow. This will be a real great help you are offering to me. Thank you so much!

If you’ve any questions or feedback, please feel free to contact me.

Please visit



Flower and Leaf Gold Texture Elements

Screen Shot 2015-09-11 at 2.59.27 pm

This exclusive freebie contains gold texture elements (PNG transparent) in 8 different flower and leaf styles. Use them on t-shirts, wedding cards and invitations, business cards, logos, packaging and more. All elements come in high resolution with 2500×2500 pixels, 300 dpi.

You can buy the full set of 67 gold texture elements on Creative Market.


Screen Shot 2015-09-11 at 3.00.52 pm Screen Shot 2015-09-11 at 3.01.19 pm

Flat Responsive Design Template

Screen Shot 2015-09-11 at 4.18.01 pm

The Flat Responsive Design Template is suitable for computer, laptop tablet and smartphone. Files include EPS, PNG, PSD, AI and SVG and include some cute icons in vector format.

This exclusive freebie is thanks to our friends at Brusheezy.


Screen Shot 2015-09-11 at 4.18.28 pm Screen Shot 2015-09-11 at 4.18.46 pm Screen Shot 2015-09-11 at 4.19.05 pm Screen Shot 2015-09-11 at 4.19.22 pm

1 2 3 16