How to Perform a Mail Merge in Word 2010 (with Pictures) #merge


How to Perform a Mail Merge in Word 2010

How to Overline Characters in Microsoft Word

How to Mail Merge in Microsoft Word

How to Add Page Numbers or Page X of Y Page Numbers in Word

How to Add Clip Art to Microsoft Word

How to Insert a Line in Word

How to Add Font in Microsoft Word

How to Turn a Scanned Document Into Microsoft Word Document

How to Rotate Text in Microsoft Word

How to Remove a Blank Page in Word

How to Add a Footnote to Microsoft Word

Automating Mail Merge using Excel VBA – Stack Overflow #mail #merge #from


My Name is Hema and this is my First Macro and first post in Stack overflow.

I have created a macro in Excel where I can mail-merge data from Excel into Word Letter Template automatically and save the individual files in the folder.

I have a Employee data in Excel and I can generate any Employee letter using that Data and can save the individual Employee letter as per the Employee name.

I have been successful to run mail-merge automatically and save individual files as per the Employee name. And every time it runs the file for one person it will give the status as Letter Already Generate so that it wont duplicate any Employee records.

Now the only problem I am facing is the output in all the merged files the output is same as the first row. Example: if my Excel has 5 Employee details I am able to save the 5 individual merged files on each employee name, however the merged data if of the first employee who is in Row 2 only. In all the files the data is showing for the first row employee.

I couldn’t attached the files but my rows have the below data: Row A. has S.No. Row B: has Empl Name Row C: has Processing Date Row D: has Address Row E: Firstname Row F: Business Title Row G: Shows the status (if the letter is generated it shows “Letter Generated Already” after running the macro or it shows blank if it is new record entered.

Also request someone to add a code where I can save the output (merged file) also in PDF other than DOC file. So the merged files will be in two formats one in Doc and the other one in PDF formats.

Thank you very much in Advance hope to listen from someone shortly.

To save the file in pdf format use

It looks to me that when you are executing the mail merge, it should create a file with ALL of the letters, so when you open it, it would appear that the first letter is the one that is getting saved, but if you scroll down the word file that you have saved, you may find each letter on a new page.

Instead, you want to execute the merge one letter at a time.
To fix this, change the lines as follows:

You need to use r-1 because Word is going to use the record number in its dataset, and since the data starts in row 2, and the counter r is related to the row, you need r-1 .

You don’t need to open up word each time, so put all of the code setting the datasource of the mail merge and creating the word doc outside of your main loop.

Also, instead of checking the Excel file for the Employee name to create the file name, you could do this after you merge the document. For me, this is a little more intuitive to link the file name to the letter you have just merged. To do this update the line further to:

Then immediately before saving the file you can do this:

Hope this helps.

Git subtree: the alternative to Git submodule #git #merge #–no-commit


Git subtree: the alternative to Git submodule

Fresh ideas, announcements, and inspiration for your team, delivered weekly.

(Updated in January, 2017.)

The Internet is full of articles on why you shouldn t use Git submodules. I mostly agree, although I am not so harsh in my evaluation. As I explained in a previous post. submodules are useful for a few use cases but have several drawbacks.

Are there alternatives? The answer is: yes! There are (at least) two tools that can help track the history of software dependencies in your project while allowing you to keep using Git:

In this post I will be looking at git subtree and show why it is an improvement albeit not perfect over git submodule. As a working example, I run to my usual use case: How do I easily store and keep up to date the vim plugins used in my dotfiles ?

What is git subtree. and why should I use it?

git subtree lets nest one repository inside another as a sub-directory. It is one of several ways Git projects can manage project dependencies.

There are several reasons git subtree is worth considering:

  • Management of a simple workflow is easy.
  • Older version of Git are supported (even older than v1.5.2).
  • The sub-project s code is available right after the clone of the super project is done.
  • git subtree does not require users of your repository to learn anything new. They can ignore the fact that you are using git subtree to manage dependencies.
  • git subtree does not add new metadata files like git submodule does (i.e. gitmodule).
  • Contents of the module can be modified without having a separate repository copy of the dependency somewhere else.

There are also a few drawbacks, but in my opinion they re are acceptable:

  • You must learn about a new merge strategy (i.e. git subtree ).
  • Contributing code back upstream for the sub-projects is slightly more complicated.
  • The responsibility of not mixing super and sub-project code in commits lies with you.

How to use git subtree

git subtree is available in stock version of Git since May 2012 – v1.7.11 and above. The version installed by homebrew on OSX already has subtree properly wired, but on some platforms you might need to follow the installation instructions.

Let me show you the canonical example of tracking a vim plug-in using git subtree .

The quick and dirty: way without remote tracking

If you just want a couple of one-liners to cut and paste, read this paragraph. First add git subtree at a specified prefix folder:

(The common practice is to not store the entire history of the subproject in your main repository, but If you want to preserve it just omit the squash flag.)

The above command produces this output:

As you can see this records a merge commit by squashing the whole history of the vim-surround repository into a single one:

If after a while you want to update the code of the plugin from the upstream repository you can just do a git subtree pull :

This is very quick and painless, but the commands are slightly lengthy and hard to remember. We can make the commands shorter by adding the sub-project as a remote.

Adding the sub-project as a remote

Adding the subtree as a remote allows us to refer to it in shorter form:

Now we can add the subtree (as before), but now we can refer to the remote in short form:

The command to update the sub-project at a later date becomes:

Contributing back upstream

We can freely commit our fixes to the sub-project in our local working directory now. When it s time to contribute back to the upstream project, we need to fork the project and add it as another remote:

Now we can use the subtree push command like the following:

After this we re ready and we can open a pull-request to the maintainer of the package.

Can I do this without using the git subtree command?

Yes! Yes you can. git subtree is different from the subtree merge strategy. You can still use the merge strategy even if for some reason git subtree is not available. Here is how you would go about it.

Add the dependency as a simple git remote :

Before reading the contents of the dependency into the repository, it s important to record a merge so that we can track the entire tree history of the plug-in up to this point:

We then read the content of the latest tree-object into the plugin repository into our working directory ready to be committed:

Now we can commit (and it will be a merge commit that will preserve the history of the tree we read):

When we want to update the project we can now pull using the git subtree merge strategy:

Git subtree is a great alternative

After having used git submoduls for a while I appreciate git subtree much more because it solves lots of the problems with git submodule. As usual, with all things Git, there is a learning curve to make the most of the feature.

Further reading

Other Git articles you might find interesting:

If you re new to Git, or want to deep-dive on a few commands, head to our free Git resource hub for tutorials, workflows, and articles. Git it?

Horizon, JourneyCare and Midwest Merge to Enhance Patient Care #hospice #chaplain #training

#midwest palliative & hospice carecenter


Horizon, JourneyCare and Midwest Merge to Enhance Patient Care

Three of Illinois’ leading palliative and end-of-life care providers announced today they have entered into an agreement to merge into one agency which, when fully integrated, will become one of the premier non-profit palliative and end-of-life care providers in the state.

Under the terms of the agreement, Chicago-based Horizon Hospice Palliative Care, Barrington-based JourneyCare and Glenview-based Midwest Palliative Hospice CareCenter will operate as a single entity. When combined, the organization will employ more than 800 health care professionals and care for thousands of patients annually in Chicago and 10 surrounding counties.

“We are excited to combine the incredible talent and compassion of three strong organizations, which will expand the breadth and depth of services for patients and their families across a much larger footprint,” said Sarah Bealles. who was selected to become President and CEO of the newly combined agency, moving from her current role as President and CEO of JourneyCare.

“Each of us shares the same vision, which is to provide exceptional care and compassion to our patients and their loved ones. We are honored to be entrusted with their care at this very intimate time in their lives. This will never change,” Bealles shared. “However, by joining together we will be able to integrate our strengths while leveraging our combined infrastructure and expertise. This agreement positions us to take a lead in defining how care is delivered in the transforming health care market,” Bealles added.

The merger will bring together three highly respected community-based organizations which have more than 100 years of combined experience in the fields of palliative medicine and end-of-life care. The new agency’s name is expected to be announced by late summer.

Collectively, the three organizations have five inpatient hospice centers – located in Barrington, Woodstock, Arlington Heights, Glenview and Chicago – and six offices in the greater Chicago area. These facilities will remain fully operational, and the new agency’s corporate functions will be dispersed throughout its existing offices.

With 40 acute-care hospital affiliations and numerous post-acute partnerships, the new organization will care for approximately 2,500 patients daily. All existing partnerships are expected to remain in place, and all employees will be transitioned into roles within the new agency.

The combined organization will be led by a newly elected 18-person board, with six members chosen from each provider’s current board. Following the closing, up to four additional independent voting members may also be chosen from outside of the organizations within a year after closing.

“The health care industry is not standing still and neither can we,” said Jamie O’Malley, CEO of Midwest CareCenter. “As three of Illinois’ founding palliative and end-of-life care providers, we’re moving forward together to continue to take the lead in finding innovative ways to enhance care for the seriously ill.”

“Our announcement today goes a long way toward increasing access to care for a diverse population of people while increasing efficiencies and improving integration and collaboration with all of our health care partners,” said Mary Runge, CEO of Horizon. “We’re proud to be a part of this merger, which truly forms the premier palliative and end-of-life provider in the region.”

Mary Runge, CEO of Horizon, and Jamie O’Malley, CEO of Midwest CareCenter, will remain in active roles through the transition.

“I’m so grateful to have the support of Mary and Jamie as we move forward through this integration,” Bealles said. “Their deep knowledge and passion for providing excellent patient care will be instrumental in making this transition process seamless for our patients, their families and our employees.”

About Horizon Hospice Palliative Care
Horizon Hospice Palliative Care has been a pioneer for end-of-life care, providing comfort and dignity to our patients and their families – regardless of the ability to pay – for 37 years. As the first hospice in Illinois, we are proud of the legacy we’ve built and proud to lead the industry in expert care through innovation, excellence and compassion.

About JourneyCare
As Chicagoland’s largest nonprofit provider of palliative and end-of-life care, JourneyCare has served generations of families in Chicago and the surrounding 10 counties since 1982. Through compassionate and transformative approaches to care, JourneyCare supports over 1,000 patients and families each day in navigating physical, spiritual, social and emotional issues surrounding advanced illness, helping them to live as fully as possible. Founded over three decades ago by a small group of pioneering community volunteers, JourneyCare remains committed to its mission of making every moment count for those touched by serious illness and loss.

About Midwest Palliative Hospice CareCenter
As one of the first 50 hospices in the U.S. Midwest CareCenter provides palliative medicine and end-of-life care to patients and their families in 150 communities. The organization has a long history as an award-winning innovator in health care, caring for more than 4,000 patients each year. Midwest CareCenter has earned the American Hospital Association Circle of Life Award and has been named a Top 100 Workplace by the Chicago Tribune for the past three years.



Featured Video

Hospice of Piedmont, Rapidan merge #motels #brisbane

#hospice of the piedmont


Hospice of Piedmont, Rapidan merge

Providing end-of-life care with dignity is becoming a collaborative effort.

The Hospice of the Piedmont, based in Charlottesville, recently announced its intent to merge its nonprofit organization with the Culpeper-based nonprofit Hospice of the Rapidan. The proposed merger is slated for final integration by October, according to a news release.

Hospice of the Rapidan board member Neil Mairs, of Culpeper, said Tuesday that the Culpeper office would remain open as part of the merger.

“It appears it will be a lot of business as usual,” he said of the consolidation. “Except we will be able to provide the same compassionate care to our patients and their families for 30 years to come, and more.”

The decision to merge the two hospice organizations arose out of the current health care environment making it more and more difficult for nonprofits, especially, to survive, said Mairs, a 12-year member of the Hospice of Rapidan Board.

The question the board faced, he said, is how could the organization evolve and develop the critical mass to remain sustainable longterm? Joining forces with Hospice of the Piedmont made good sense, said Mairs.

“The cultural fit is strong. They share the same approach as we do in taking care of our patients,” he said.

Dr. James Avery, CEO of Hospice of the Piedmont, said the partnership would build upon the strengths and great legacies of both organizations allowing them to better face the challenges all health care companies will be experiencing in the years to come, according to a news release.

The new partnership is expected to strengthen and improve the delivery of hospice care in Central Virginia while making high quality compassionate care available to more patients and their families, according to the release.

As part of the merger, the hospice organization will be headquartered in Charlottesville with a permanent satellite office in Culpeper. The combined hospice groups will continue to serve patients and families in the counties of Augusta, Buckingham, Culpeper, Fauquier, Greene, Fluvanna, Madison, Louisa, Nelson, Orange and Rappahannock as well as the city of Charlottesville.

Recently, Hospice of the Rapidan announced the opening of a second office in Warrenton. Mairs said the plan is to keep the new office open and the same hospice teams in place.