About

Applications,

Tuesday, April 23, 2013

VBA Tech Primer on using MS Access to Send Email

 
Subject: Tech Primer on using MS Access to Send Email 
By Pete Bennett htpp://pcbenett.blogspot.com 
Posted:     04/23/2013 11:29:43 AM PDT 
Updated:    04/23/2013 02:16:02 PM PDT
Location: Walnut Creek CA

VBA - Visual Basic for Applications - Scripting, ASP, MS Office Automation

VBA - Visual Basic for Applications -

VBA has been around for over 20 years.  In the early days it was a limited to core functions supporting MS Access, Excel, Word and Windows Server functions such as login scripts.  The early days of DOS were used to manage logins to Novell Servers which was the impossible to catch leader for nearly a decade. 


Scripting,

Active Server Pages (ASP)
Developed by Microsoft in mid nineties as their foray so the Windows NT Servers could be sold as supporting web sites.  The IIS model 5.0 was pretty crude compared to current standards but then few hardly cared about online attacks such as the NIMBA virus. 



MS Office Automation

This is where MS Access can take over MS Outlook or send data to MS Word to Publish a mailing list or mailmerge.  

Sunday, April 14, 2013

Craigslist Ad 101 Oakland Downtown


Great Rates / Fast Service / Over 20 years direct client consulting / ASP.NET Experts

Hard Technical:

  • ASP.NET, VB.NET, C# and SQL Server Development
  • Windows Web Development using Visual Studio 2010
  • Expert level with XML and XSLT
  • Comfortable with using .NET library with XML
  • Intermediate level with XML and XSLT
  • Thorough understanding of core ASP.NET
  • Object models, data model, and web service design
  • Entity Framework, LINQ, Strong Data Patterns
  • Siilverlight, AJAX, JavaScript, Jquery

MS Office Skills - Expert Level

  • MS Access Databases from cradle to grave
  • MS Access Developer
  • MS Outlook - Custom Add-ins, Custom VBA Scripting
  • MS Publisher
  • MS Word Integration using RTF to create complex data driven forms
  • MS PowerPoint - complex business driven presentations
  • MS Excel - functions, formulas and data access

Consulting Services

  • Business Development
  • CRM Systems and Selections
  • Legal and Business Strategies
  • Business Process Development
  • Internal Forms Development
  • Business Inteligence

Qualifications:

  • Over 20 years of software development
  • Over 30 years of business acumen
  • Strong Legal Background - thorough understanding of tort and contract law
  • Strong analytical capabilities
  • Passionate commitment to engineering quality and productivity
  • Self Regulated, Self Directed and Self Taught
  • More

Other Technical Skills

  • Code/Logic
  • User Interface
  • Reporting
  • Security/Authentication
  • Application

Utilizing the latest Microsoft Tools/Architecture

  • Microsoft Web Applications and Services
  • Microsoft SQL Server Database Applications
  • Microsoft Windows Applications
  • Microsoft Azure Cloud Applications Mobile Applications

Industries Served


  • Banking, Mortgage, And Finance
  • Real Estate, Real Estate Firms and Mortgage Operations
  • Construction, Construction Manangement
  • High Tech, Software and Hardware Companies
  • Medical, Hospital, Records Management
  • Manufacturing, ERP, MRP
  • Small Business Enterprise

What you need to know about Pete Bennett :d to know about Pete Bennett :
  • Has appeared on CNN, ABC and Wall Street Journal
  • Speaker and pPesenter
  • Seasoned Musician and Performer
  • Worked at Fortune 10 Companies
We pride ourselves on delivering more than just great programming -- we deliver true software consultation. We are talented, self-directed individuals who flourish while working under tight deadlines. Our development environment is high energy with quick cycles. Individual work is critical to projects, and success stands out.

DDD
Amtrak Stops Stop Here and There Traveling Amtrak and enjoy working via Wifi
Azure Experts Expert Advice and Articles on Azure (SQL Cloud)
Azure Expert We're Microsoft Developers and prefer Azure
Azure Expert We're Microsoft Developers and prefer Azure
Bay Area Open Mics bayareajam
Bay Area Sightseeing Sharing 35 years of destinations
Email Market Directory - Resource Locator Bay Area Sightseeing
Bay Area Sightseeing Localized, Accurate and Full of Fun
Bay Area Surplus Someone wants to get rid of something everyday
Casino Vacation Reports This will be fun covering CA, NV, WA and OR
Cell Phone Index We've got the contacts for inside information

Craiglist.com Contact Us Page

Welcome from Craigslist.com

You've landed on Pete Bennett blog created specifically for visitors coming from Craig's site.  This page is part filter and partly a welcome page.

The filter is on for the same it's getting harder and harder to post on Craigslist due the the endless spammers who use all sorts of tricks. 

Craigslist Ad #100

Microsoft Developer and Blogger (financial district)

PLEASE VISIT MY BLOGGER SITE

510-460-5641

Great Rates / Fast Service / Over 20 years direct client consulting / ASP.NET Experts

Hard Technical:

  • ASP.NET, VB.NET, C# and SQL Server Development
  • Windows Web Development using Visual Studio 2010
  • Expert level with XML and XSLT
  • Comfortable with using .NET library with XML
  • Intermediate level with XML and XSLT
  • Thorough understanding of core ASP.NET
  • Object models, data model, and web service design
  • Entity Framework, LINQ, Strong Data Patterns
  • Siilverlight, AJAX, JavaScript, Jquery

MS Office Skills - Expert Level

  • MS Access Databases from cradle to grave
  • MS Access Developer
  • MS Outlook - Custom Add-ins, Custom VBA Scripting
  • MS Publisher
  • MS Word Integration using RTF to create complex data driven forms
  • MS PowerPoint - complex business driven presentations
  • MS Excel - functions, formulas and data access

Consulting Services

  • Business Development
  • CRM Systems and Selections
  • Legal and Business Strategies
  • Business Process Development
  • Internal Forms Development
  • Business Inteligence

Qualifications:

  • Over 20 years of software development
  • Over 30 years of business acumen
  • Strong Legal Background - thorough understanding of tort and contract law
  • Strong analytical capabilities
  • Passionate commitment to engineering quality and productivity
  • Self Regulated, Self Directed and Self Taught
  • More

Other Technical Skills

  • Code/Logic
  • User Interface
  • Reporting
  • Security/Authentication
  • Application

Utilizing the latest Microsoft Tools/Architecture

  • Microsoft Web Applications and Services
  • Microsoft SQL Server Database Applications
  • Microsoft Windows Applications
  • Microsoft Azure Cloud Applications Mobile Applications

Industries Served

  • Banking, Mortgage, And Finance
  • Real Estate, Real Estate Firms and Mortgage Operations
  • Construction, Construction Manangement
  • High Tech, Software and Hardware Companies
  • Medical, Hospital, Records Management
  • Manufacturing, ERP, MRP
  • Small Business Enterprise

What you need to know about Pete Bennett :d to know about Pete Bennett :
  • Has appeared on CNN, ABC and Wall Street Journal
  • Speaker and pPesenter
  • Seasoned Musician and Performer
  • Worked at Fortune 10 Companies
We pride ourselves on delivering more than just great programming -- we deliver true software consultation. We are talented, self-directed individuals who flourish while working under tight deadlines. Our development environment is high energy with quick cycles. Individual work is critical to projects, and success stands out.

DDD
Amtrak Stops Stop Here and There Traveling Amtrak and enjoy working via Wifi
Azure Experts Expert Advice and Articles on Azure (SQL Cloud)
Azure Expert We're Microsoft Developers and prefer Azure
Azure Expert We're Microsoft Developers and prefer Azure
Bay Area Open Mics bayareajam
Bay Area Sightseeing Sharing 35 years of destinations
Email Market Directory - Resource Locator Bay Area Sightseeing
Bay Area Sightseeing Localized, Accurate and Full of Fun
Bay Area Surplus Someone wants to get rid of something everyday
Casino Vacation Reports This will be fun covering CA, NV, WA and OR
Cell Phone Index We've got the contacts for inside information
Cell Phone Index Carriers, Plans and Trens
Cloud Finder We are Cloud Finder! A clear concise directory
Cool Tech Products As the name goes - cool we want to know
Craigslist Rewired Making the CL Experience better
Domains Explained Mail, web, DNS, Hosting Tips and Techniques
Email Market Directory - Resource Locator Email Marketing Directory
Email Market Directory - Resource Locator Email Market
Email Universe Complete Online Directory
Hire Pete Microsoft Custom Programming Services
HTML5 Morsels HTML5 Bite Sized Morsels
Livermore Wine Country Clean directory of Livermore Wineries
Napa Valley Winery - Best of Napa Valley Another clean directory by yours truly
Napa Valley Wine Train Another clean directory linked to our winery list
Napa Valley Winery Clean Accurate Directory
SQL Edu - Get The Tips Examples, training, providers and examples
Visual Basic Developer We're passionate about Visual Basic Development
Visual Studio Controls A clean and clear directory of controls
Walnut Creek Restuarants Eat Drink and be Merry
Aweber Email, Mass Mailer,
Keywords of love:

Customer Solutions - Outlook Automation

Customer Solution:

Computer Programmer
Walnut Creek Company
April 2007 - August 2010 - Walnut Creek, CA
Developed custom applications are requested using Outlook, Access and VB - Contract work at random times over 5 years
Skills: ASP, Outlook, VBA, Web HTML, ETL, SQL Server 7/2000/2005, Microsoft Word 2003




Developed custom connectors by integrating VBA, MS Access, VB, with Outlook VBA that processed zipped files that arrived as attachments for daily reports, files and datasets.  The MS Access program monitored Outlook via the library, then processed the attachments by unzipping, reading the files, parsing the headers then reformatted the data for Yardi Systems General Ledger property management module.

The client was consuming several hours per day for a daily task that was very tedious that few in the offices wanted to deal with. The net savings in man hours was about 16 to 20 hours per week or the equivalent of  part time employee's salary.

Net savings in a professional office was significant enough to justify project.
Payroll Savings: $15,000
Project Cost: $4,000 


Windows XP and Vista

Windows XP and Vista

Prior Version Support

Windows Sections

Windows 7

Windows 8 Apps

Best apps for Windows 8 2012

Windows 8 only entered the software scene two months ago, yet despite rumors to the contrary, the software in the Windows Store is growing strong, with nearly 20,000 apps and counting so far.

Windows 8--along with the launch of Windows' new "Modern UI" (a.k.a. Metro)--was designed with touchscreens and desktops in mind, but can any one OS do both well? Although it's far too early to pick the long-term winners for Windows 8, we've spent enough time with the Surface RT and the desktop version to make our picks for the best Windows 8 apps of 2012.

Misc Tools

MS Office Blogs

.NET Development





SQL Edu - Get The Tips Examples, training, providers and examples
Visual Basic Developer We're passionate about Visual Basic Development
Visual Studio Controls A clean and clear directory of controls

Travel Blogs

Coming Soon ....

Blog Index

One of many blogs - note: some are under construction

Amtrak Stops Stop Here and There Traveling Amtrak and enjoy working via Wifi
Azure Experts Expert Advice and Articles on Azure (SQL Cloud)
Azure Expert We're Microsoft Developers and prefer Azure
Azure Expert We're Microsoft Developers and prefer Azure
Bay Area Open Micsbayareajam
Bay Area Sightseeing Sharing 35 years of destinations
Email Market Directory - Resource LocatorBay Area Sightseeing
Bay Area Sightseeing Localized, Accurate and Full of Fun
Bay Area Surplus Someone wants to get rid of something everyday
Casino Vacation Reports This will be fun covering CA, NV, WA and OR
Cell Phone Index We've got the contacts for inside information
Cell Phone Index Carriers, Plans and Trens
Cloud Finder We are Cloud Finder! A clear concise directory
Cool Tech Products As the name goes - cool we want to know
Craigslist Rewired Making the CL Experience better
Domains Explained Mail, web, DNS, Hosting Tips and Techniques
Email Market Directory - Resource LocatorEmail Marketing Directory
Email Market Directory - Resource LocatorEmail Market
Email UniverseComplete Online Directory
Hire Pete Microsoft Custom Programming Services
HTML5 MorselsHTML5 Bite Sized Morsels
Livermore Wine Country Clean directory of Livermore Wineries
Napa Valley Winery - Best of Napa Valley Another clean directory by yours truly
Napa Valley Wine Train Another clean directory linked to our winery list
Napa Valley Winery Clean Accurate Directory
SQL Edu - Get The Tips Examples, training, providers and examples
Visual Basic Developer We're passionate about Visual Basic Development
Visual Studio Controls A clean and clear directory of controls
Walnut Creek RestuarantsEat Drink and be Merry
Aweber Email, Mass Mailer,



Sample Applications

Sample Applications

Northwind Database - SQL Server - MS Access 

Outlook, VBA, AppCmd or Visual Basic Developer.

Please visit the blog index page for more details. 

Business - You're in a Shark Tank

Your Business Needs to Survive 
Today most companies are well acquainted with the software tools unlike in the 1980's when applications would arrive like the tide and exit into the wind.  Those early days were definitely challenging but on occasion there are still some technology hold-outs, a firm that's postponed upgrades, service releases that brings everything to complete stop.  From paper to paperless, from pen to keyboard there is a solution available as open source, off the shelf (boxed), or the only way or best method is custom development. 

A typical problem might be to convert transaction file from one format to another or perhaps an e-commerce system reports don't fit the business model.  An early mistake could be a long term headache but even with all the planning efforts bottlenecks surface.  The workers in the warehouse are sometimes the best providers of solutions that ultimately solve efficiency issues requiring remediation.  Those in the organization who oversee day to day operational issues deal with the business process up close.

The needs assessment might the first stop in the review process but some clients already have highly focused requirements or they will come with specifications from a vendor who requires a specific process to be implemented.

Many past projects are integration based where the software is connected to an Application Program Interface (API) where the end point (The Customer) will connect via web services to their vendors back end system.  A good example is Ebay resellers who've become high volume operations soon find that Ebay's system works great but falls short in many areas thus the need for custom development linking their accounting or shipping directly to orders rather replicating orders in a separate system. 


Internet Development

Terminology Primer

Web development refers to building, creating, and an maintaining websites. It includes aspects such as web design, web publishing, web programming, and database management.

Clients often confuse "web developer" and "web designer" with webmaster are often used synonymously, they do not mean the same thing. Technically, a web designer only designs website interfaces using HTML and CSS. A web developer may be involved in designing a website, but may also write web scripts in languages such as PHP and ASP. Additionally, a web developer may help maintain and update a database used by a dynamic website.

Web development includes many types of web content creation. Some examples include hand coding web pages in a text editor, building a website in a program like Dreamweaver, and updating a blog via a blogging website. In recent years, content management systems like WordPress, Drupal, and Joomla have also become popular means of web development. These tools make it easy for anyone to create and edit their own website using a web-based interface.
While there are several methods of creating websites, there is often a trade-off between simplicity and customization. Therefore, most large businesses do not use content management systems, but instead have a dedicated Web development team that designs and maintains the company's website(s). Small organizations and individuals are more likely to choose a solution like WordPress that provides a basic website template and simplified editing tools.
NOTE: JavaScript programming is a type of web development that is generally not considered part of web design. However, a web designer may reference JavaScript libraries like jQuery to incorporate dynamic elements into a site's design.