How To Mail Merge Data And Pictures From Excel To Word?

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ต.ค. 2024
  • If you have a list of students’ information which contain the names, ages, courses, colleges and photo paths in Excel worksheet, now, you want to make an exam admission card for each student in Word. To make this type of card quickly and easily, the Mail Merge feature in Word can help you.
    Click the following link to view more detailed information:
    www.extendoffi...
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 10

  • @moomoo644
    @moomoo644 หลายเดือนก่อน +1

    Is this a one time use mail merging method? I'm trying to save a word doc template that contains the mail merge linkage for future use too. I tried other methods but I wasn't able to save it for future use. My goal is to update the source excel file periodically and reprint the mail merge d with new data and images.

  • @kerenddori7468
    @kerenddori7468 7 หลายเดือนก่อน

    Thank you for the great tutorial, but I have another question, After filling the images in pages I want to email each page to the different person, but the filling process is after the F9 command, is it work the same way with sending email?

  • @thesantosfamily
    @thesantosfamily 4 หลายเดือนก่อน

    Thank you so much! I was following other tutorials but couldn't make it work. It worked with using the "Quickparts --> field -->Include picture" method. So happy!

  • @colsar
    @colsar ปีที่แล้ว

    Hi, this is exactly what I was looking for. If I save my Word document though (the original, not the merged one with all the pages) it brings in random pictures and when I to finish & merge again, the format of the pictures goes crazy. Some are the size that I set and others are full size. Any idea why that's happening!?

    • @ExtendOffice99
      @ExtendOffice99  ปีที่แล้ว

      Hello friend,
      Glad to help. I guess the problem is that you used finish & merge twice. I highly recommend you strictly follow our tutorial to get the correct result. Here is the detailed step-by-step guide: www.extendoffice.com/documents/excel/7074-mail-merge-images-from-excel.html
      Hope it works. Have a nice day.
      Sincerely,
      Mandy

  • @rainrain251088
    @rainrain251088 ปีที่แล้ว

    thank you so much, I can made it. wish you and your team all the best.

  • @ΝΙΚΟΛΑΟΣΝΑΝΤΣΟΠΟΥΛΟΣ
    @ΝΙΚΟΛΑΟΣΝΑΝΤΣΟΠΟΥΛΟΣ ปีที่แล้ว

    what happened to the case that images do not have the same extension?

    • @ExtendOffice99
      @ExtendOffice99  ปีที่แล้ว

      Hello friend,
      Glad to help. Actually, it won't matter whether the images have the same extension as long as the image file path is correct. You can have a try of the method in the video. Any questions, please feel free to contact us.
      Have a nice day.