#1
|
|||
|
|||
Group Category Mail Merge
Dear Sir,
Hi - I need to create a mail merge template that groups items from one column in the source data (xls) and returns a list of records to that category (which is a person). The methodology is likely going to be this, but I can't figure it out. https://support.microsoft.com/en-us/kb/294686 Sir, I am asking second time this kind of mail merge as I am unable to understand the working of this code. I have copied, pasted and edited this code as per my requirements but it is not working for me. Please guide me as how this code work for my custom file? Kind Regards Shehbaz H. |
#2
|
||||
|
||||
I have previously given you links to my tutorial, which includes fully-working field code examples for this. I suggest you read it and adapt the code to your needs.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Dear Sir,
Hi You always guide me in different crucial times. I need to know the explaination of merge field codes. Please guide me about the Set Place="1" and {if{Place2}<>{Place1}" as what is the meaning of Place 1 and 2 and what is the condition say and what is the meaning of commas. Please let me know Sir. Moreover, at the start of this code the word "Quots" is also used what is the purpose of this keyword? Kind Regards Shehbaz H. |
#4
|
||||
|
||||
The tutorial does not use those fields - they are from Microsoft's example. The field coding in the tutorial is superior - I suggest you use that. The tutorial also explains the field coding...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Sir, I have checked your tutorial. The data fields and not showing on right places and scattered from the margin as I have left aligned each field.
Please view the result and guide accordingly: http://prntscr.com/986s1p http://prntscr.com/986sad Kind Regards Shehbaz H. |
#6
|
||||
|
||||
Those problems have nothing to do with mailmerge as such - it is entirely a matter of how you have formatted your document, specifically regarding tab-stops. If you had copied the field coding with the paragraph break of the paragraph they're attached to, you would obtain the same layout as in the tutorial.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Sir, I have tried it through Microsoft Code and the no output result.
http://screencast.com/t/qEseoeXXhzI |
#8
|
||||
|
||||
I am not interested in supporting the Microsoft Code. I am content to support my own, superior, code. You also give yourself less chance of solving your problem if you keep switching between methods without focussing on just one and understanding how it works.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Sir, I have tried to exercise your second example:
http://prntscr.com/98756k I can not understand it; i need to get the concept so that i could configure my own documents. This only shows <<representative>> <<sale>> and nothing else. Please see http://prntscr.com/9875pm here is the output: http://prntscr.com/9875tf Please guide how should configure example no.2 Regards I need to mention here that I have successfully formatted example no.1 and have no issue about it. |
#10
|
||||
|
||||
Then how about actually reading the tutorial, as you have been advised to do...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Sir, what is the purpose of braces [] in code? Can you suggest me what is important thing in example 2 which is missing by me?
|
#12
|
|||
|
|||
Sir, with due respect I am sorry to say that your tutorial is beyond my insight. Can you please guide me about the Microsoft Code which I request earlier showing no result. I shall be highly thankful to you. If I am unable to understand a thing then what should I do. It is my fault to understand but I want to do my assignment at any cost. Please help me Sir.
|
#13
|
||||
|
||||
These questions you keep asking are all answered in the tutorial. All you need to do is read it!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#14
|
|||
|
|||
Dear Sir,
After continuous tries I have find my solutions. Please see the below: http://screencast.com/t/muuPZ5aAMhKG Sir, I need your little guidance as I have missing two static words Thanks Management with last records while it is displayed fine with all record except last. Please guide what should I do to get it with the last record. Regards |
#15
|
||||
|
||||
Read the tutorial - it's all explained in there.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - Send Each Category to a New Page | cjw | Mail Merge | 2 | 10-23-2014 01:25 PM |
How to group with mail merge | pintail | Mail Merge | 1 | 05-28-2014 03:17 PM |
How to use mail merge to create a list sorted by category in Word | elisa2013 | Mail Merge | 5 | 03-14-2014 02:35 AM |
Need advice on category sorted e-mail merge | GeoB | Mail Merge | 3 | 09-08-2011 11:03 PM |
Where is the category or distribution list or group as I add new e-mail address? | Jamal NUMAN | Outlook | 0 | 11-21-2010 07:34 PM |