?
Solved

Word or Publisher mail merge, but some some manual imput

Posted on 2012-09-21
5
Medium Priority
?
492 Views
Last Modified: 2012-09-27
Hello

I have a mailing list that I am going to merge with Microsoft Word or Publisher 2007.

But I want an employee to be able to manually enter some data on each page of the merge so that the page can be  customized for each recipient.

For example. The name and address will be merged the usual way, but I want the employe to be able to go page by page and manually add some custom content in the same place on the page.  

Ideally it would be a "placeholder" that would prompt the employee to add the custom content.

For example

The letter would be merged to show all of the names and addresses as follows:

John Smith
123 Orange Avenue
Los Angeles, CA 90049

Dear Mr. Smith,

We would like to send you a bunch of money in the amount of{{Employee manually enter the amount of the bunch money that goes to this person }} just for giving us a call today!

Regards

Company Name.

Not sure if this can be done in Word or Publisher.  Perhaps there is a mail merge "add on" that could do it???
0
Comment
Question by:Rowby Goren
  • 4
5 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 2000 total points
ID: 38424005
I take it that you don't want to add the 'placeholder' as a new field in your mail merge list so that the employee can just edit the list by adding the amounts there; then when the mail merge is done, the letters are complete with the names and amounts.

So to do it the other way as you described.  You need to add the placeholder before clicking on Finish & Merge in the Finish section of the Mailings tab in the MS Word's Ribbon.
Here's a link with step by step directions: Create forms that users complete or print in Word

You just need the first part of Step 3 (Insert a text control where users can enter text) and then Step 5 to add something like "Enter amount here."

After that, when you merge and it creates individual documents, each page will have the placeholder.
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38424815
Hi IrogSinta

Thanks for your comments.  Looks good!

 I will be gone all of today and probably most of Sunday so I will check it out on Monday the latest.

Thanks!

Rowby
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38430904
Hi

Did a test and sent it to my friend who wants it.

I'll get his feedback once he looks at it.

I think it will work fine.

Rowby
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 38432706
Thanks  Your solution is what I needed.  I will keep this question open until Thursday in case my friend has any additional questions about using the merge / placeholder
0
 
LVL 9

Author Closing Comment

by:Rowby Goren
ID: 38441116
Thanks.   The placeholder is working nicely!  Rowby
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question