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
Tuesday, April 23, 2013
VBA Tech Primer on using MS Access to Send Email
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.
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
| 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.
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)
|
Customer Solutions - Outlook Automation
Customer Solution:
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
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 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.
.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 |
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.
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.
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.
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.
Subscribe to:
Comments (Atom)
