Aspose.com » Public Forums for Customers an... » Aspose.Words Product Family » Re: Mail Merge Avery Labels

Mail Merge Avery Labels

Last post 12-29-2009, 9:46 AM by alexey.noskov. 21 replies.
Page 1 of 2 (22 items)   1 2 Next >
Sort Posts: Previous Next

  •  12-21-2009, 4:41 AM 213949

    Mail Merge Avery Labels .NET

    Hello there,

    Could you please guide me how to process Mail Merge for Avery Labels.

    Thank you!
    Filed under: Mail Merge Labels
     

  •  12-21-2009, 7:16 AM 213987 in reply to 213949

    Re: Mail Merge Avery Labels .NET

    Any comments on this?

    Thank you!
     

  •  12-21-2009, 7:21 AM 213990 in reply to 213949

    Re: Mail Merge Avery Labels

    Hi Nutan,

     

    Thanks for your request. Maybe you can use the technique as described here:

    http://www.aspose.com/community/forums/thread/171403/label-sample-code.aspx

     

    Hope this helps.

     

    Best regards,

    Alexey Noskov
    Developer/Technical Support
    Aspose Auckland Team
     

  •  12-21-2009, 12:05 PM 214043 in reply to 213990

    Re: Mail Merge Avery Labels .NET

    Thanks for the link Alexey.

    I have gone through it and it is suggested to create TableStart/TableEnd Merge regions.

    I have done MailMerge.ExecuteWithRegions() a couple of times.
    But I am a bit confused on how I will move to individual address labels in an Avery Label document at run time.

    As you must be knowing, Avery Label document will have different no. and size of labels depending on the Avery product no. end user selects.

    Could you please guide me further.

    Thank you!
     

  •  12-22-2009, 3:02 AM 214141 in reply to 214043

    Re: Mail Merge Avery Labels .NET

    Any comments on this?
     

  •  12-22-2009, 3:48 AM 214163 in reply to 214141

    Re: Mail Merge Avery Labels

    Hi Nutan,

     

    Thanks for your request. Have you tried the example provided in the forum thread I linked to? I also attached template and output document there.

    If such technique does not fit to your needs, could you please attach your template and expected output? I will check your inputs and provide you more information.

     

    Best regards.

    Alexey Noskov
    Developer/Technical Support
    Aspose Auckland Team
     

  •  12-22-2009, 6:10 AM 214202 in reply to 214163

    Re: Mail Merge Avery Labels .NET

    Attachment: Present (inaccessible)
    Thanks Alexey,

    Yes, I tried the example provided in above link.

    But when I run same for my template(attached), it throws the error:
    Mail merge region 'Labels' is badly formed. TableStart and TableEnd should be in the same section, same table row or same table cell.

    I tried with same set of rows you have provided as an example in above thread for MailMerge.ExecuteWithRegions()

    Please guide.
    Filed under: Aspose Labels
     

  •  12-22-2009, 7:52 AM 214222 in reply to 214202

    Re: Mail Merge Avery Labels

    Attachment: Present (inaccessible)

    Hi Nutan,

     

    Thank you for additional information. Actually, if you look at your document one more time, you will see that there are two text columns, and the table has only one column. So TableStart and TableEnd mergefield are in different rows, which is not allowed. That is why the exception is thrown. I modified your template. Please see the attached document.

     

    Best regards,

    Alexey Noskov
    Developer/Technical Support
    Aspose Auckland Team
     

  •  12-22-2009, 9:05 AM 214239 in reply to 214222

    Re: Mail Merge Avery Labels .NET

    Thanks for your reply Alexey.

    Could you please tell me how can I see if these are two text columns instead of table columns.

    Further, as our clients use Avery Labels, I need to use Label templete generated by Avery wizard.
    The previous template document that I sent you was for Avery Label(Product No. L7162).
    Then I added the Merge Fields manually after opening it.

    Could you please tell me how can I run the Mail Merge for such Avery Label templates.

    Thank you!
     

  •  12-22-2009, 2:41 PM 214327 in reply to 214239

    Re: Mail Merge Avery Labels

    Hi Nutan,

     

    Thanks for your request. You can see that there are two text columns if you open this document in MS Word.

    Please attach the source template, which you need to use. I will check it and provide you more information.

     

    Best regards.

    Alexey Noskov
    Developer/Technical Support
    Aspose Auckland Team
     

  •  12-22-2009, 3:18 PM 214339 in reply to 214327

    Re: Mail Merge Avery Labels .NET

    Attachment: Present (inaccessible)
    I think I do not understand when you say text columns, can you please elaborate more.

    All I can see is a table with two columns in the attached template (the attached document is same as I attached earlier). I can even see 'Merge Cells' option when right click Table handler at top left.

    Also, please consider this document as a template against which I need to run mail merge.
    If it is not possible to run mail merge against this document, how can I modify it at run time to execute mail merge for it.

    Waiting your response.

    Thank you!
     

  •  12-22-2009, 3:32 PM 214343 in reply to 214339

    Re: Mail Merge Avery Labels

    Attachment: Present (inaccessible)

    Hi Nutan,

     

    Please find the attached screenshot. You can see that there are two columns in this section. Also if you place cursor in the first cell of this table and try to move it to the next cell using “Tab”, cursor will be moved to the cell below current.

     

    Best regards.

    Alexey Noskov
    Developer/Technical Support
    Aspose Auckland Team
     

  •  12-23-2009, 3:10 AM 214396 in reply to 214343

    Re: Mail Merge Avery Labels .NET

    hmm... I can see that now. Thanks for explaining.

    I will be having only such templates as they are created from Avery wizard.
    Could you please help me in finding a way to mail merge addresses for such templates.
     

  •  12-23-2009, 3:31 AM 214402 in reply to 214396

    Re: Mail Merge Avery Labels

    Hi Nutan,

     

    I already provided you the modified template, which you can use in mail merge process. Have you tried using the modified template I provided?

     

    Best regards.

    Alexey Noskov
    Developer/Technical Support
    Aspose Auckland Team
     

  •  12-23-2009, 3:50 AM 214407 in reply to 214402

    Re: Mail Merge Avery Labels .NET

    Attachment: Present (inaccessible)
    Two queries:

    1. As, I have discussed with you, end user is going to upload the source template he gets from Avery wizard. Do I need to modify the template manually before running mail merge?
    It would be great if I can modify such templates at run-time to execute mail-merge against it.

    2. The modified template that you attached has TableStart and TableEnd both in the same cell.
    So, instead of creating separate labels, mail merge just append all records one after another in same table cell.
    Attached is the output that I get after running mail merge against that template.

    Waiting your response.
     
Page 1 of 2 (22 items)   1 2 Next >
View as RSS news feed in XML

© Aspose 2002-2012. All Rights Reserved.

Live Chat