MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 332|Reply: 5

Mail Merge from excel file for labels not populating labels

[Copy link]

2

Topics

12

Posts

38

Integral

Member

Rank: 2

Integral
38
Post on 10-14-2016 09:03:19 | All posts |Read mode
Hello all,
Foremost, thank you for considering my post. All I want to do is simply take the information that is in columns a b and c, and have all this information appear on a single avery 5167 label. So for example, it should look like so..
Coastal AgroBusiness
Truck 611
252-414-3895
And then so on for all the other rows of data. I tried using the mail merge wizard, but it would not populate the data. Please help! Also, please explain your steps as how you solved this problem, because I want to be able to replicate.
Thank you.








  • Ryan.docx
    (12.9 KB, 0 views)
    Download

  • AMY C.xlsx
    (9.0 KB, 0 views)
    Download

  • Reply

    Props Report

    10

    Topics

    903

    Posts

    1996

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1996
    Post on 10-15-2016 15:56:42 | All posts



    This issue has been moved to the Commercial Services.
    Reply Support Opposition

    Props Report

    7

    Topics

    551

    Posts

    1283

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1283
    Post on 2-11-2017 11:37:18 | All posts



    Using the literal text from your post...
    is there a tutorial on the proper way to do a mail merge




    Reply Support Opposition

    Props Report

    2

    Topics

    23

    Posts

    66

    Integral

    Member

    Rank: 2

    Integral
    66
    Post on 2-11-2017 12:16:48 | All posts



    Point taken, I just thought this site would have more detailed information not sarcasm




    Reply Support Opposition

    Props Report

    7

    Topics

    551

    Posts

    1283

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1283
    Post on 2-11-2017 13:02:15 | All posts



    It's not sarcasm.
    You posted a very general question best answered with a very general introduction. Otherwise you're really asking someone to take the time to lay out all the ins and outs of a mail merge without knowing your particular requirements so that is something best investigated by yourself in the first place.
    If you had said I am trying to do 'x' or 'y' and my data looks like 'z' then comments on the pros and cons of each approach are possible.
    This is sarcasm










    Reply Support Opposition

    Props Report

    2

    Topics

    188

    Posts

    466

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    466
    Post on 2-11-2017 14:23:23 | All posts



    +1
    Besides which, since mailmerges are usually run from Word (regardless of the datasource), the question would probably better have been asked in Word Formatting  General: http://www.msofficeforums.com/mail-m...ps-tricks.html
    or:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks
    Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-18-2017 04:53 , Processed in 0.167712 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!