Mail Merge Problems

Hi every one I am try to Make my company staff Salary & wages Payslip by useing mail merge. My salary calculation prepared on excel. I have done almost of labels. But probles is here i must mension my company name & Salary for the month of .......................... & Before columns information need for mention columns Label

Examples

ABC Company Ltd
Salary for the month of Dec-13
Nmae: Sohel Dept: Accounts & Finance
Poisson: SR Executive ID: 10 Sl: 1
Basic Salary: 5000
Allowance:    4000
Total            9000
All information in Excel file. I can display only information but not Labels. So whats to do can u help me to do it. if possible help me with some screen shots of steps i am very new about mail merge. & also week in English

Thanks & best Regard
A mail merge document comprises fixed text typed in the document plus variable text from the data source used to populate merge fields. Provided the data comprises one line per record (one to one merge) mail merge is straight forward - see

Mailmerge with Word 2007/2010

Graham Mayor (Microsoft Word MVP 2002-2019)
For more Word tips and downloads visit my web site
https://www.gmayor.com/Word_pages.htm

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Dear sir is there any good tutorial that can help me

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Did you look at the article Graham referenced? Mailmerge with Word 2007/2010
Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

yes mam i saw but i cant understand it well. last 12 hour i am trying to solve problems but i failed. so specially is there any tutorial may be it can help me. i just need labels & field. here i try to say it again
 

Name Age Cell No Country
Sohel 31 1558836934 bangladesh
Babu 23 01913076914 bangladesh

my excel sheets like above but there is thousand of Columns & some some rows i want to create name wise all information & one one page there will be six man information

My ans need like this

Name: Babu
Age: 25
Cell no. 008801558836934
Country Bangladesh
I can able to do it without field name
thats my problems mam please help me to recover
my skype id is sohel.mostafa83

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You will have to create a label as follows:

 

Name : «Name»

Age: «Age»

Cell No: «Cell_No»

Country: «Country»

 

The parts between «» are the merge fields, which you insert using the Insert Merge Field button on the Mailings tab. All of this is quite clearly explained, step by step, with screen shots, in Graham's article at http://www.gmayor.com/merge_labels_with_word_2007.htm. You can skip over most of the stuff about selecting a data source; just navigate to the Excel file where you have your data and select it. You can also skip over all the stuff about the Address Block because you won't be using that. The information about Outlook Contacts is also irrelevant. The important first step is that you choose a label type that has six labels per sheet.

Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

thanks for all ur afford & time but fail to understand u. can u show me a example after solve that problems & if possible make some screen shot of all steps
thanks 

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This is not the place for that kind of detail. If you can't follow the instructions in Graham's tutorial, then perhaps you should just use the Mail Merge Wizard. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge and chose Step by Step Mail Merge Wizard.       

 

Alternatively, perhaps you can find a forum in your own language where you will be better able to pose your questions and understand the answers you get.

Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 222 Applies to: