How to Mail Merge Excel data and images in Microsoft Word? Picture Mail Merge.

แชร์
ฝัง
  • เผยแพร่เมื่อ 19 พ.ย. 2024

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

  • @cesarsandino6436
    @cesarsandino6436 4 ปีที่แล้ว +4

    You ROCK!!!!!!! I have 500 name cards to match up, this made it a breeze.

  • @veronvideos
    @veronvideos 3 ปีที่แล้ว +1

    Thanks so much. I follow a lot of tutorial before and none of it works. This works great!!!

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

    Thank you! Saved me a lot of time. To me it worked regardless if I used single or double slash in path.

  • @adriancollier3335
    @adriancollier3335 4 ปีที่แล้ว +1

    Hi Bidhib, thanks very much for your tutorial, I had looked on many sites trying to solve my image merge problem and your was the only that worked. From the Microsoft help there were a couple of key differences - double backslashes for the path but I think the most important part is to merge the file name separately. Thanks, Adrian

    • @kennethtrotman
      @kennethtrotman 4 ปีที่แล้ว +4

      Adrian---I've been searching for several videos myself and while I followed all of the directions correctly, it's still having issues. I was wondering what version of Excel and Word you were using so I could be sure I'm using the needed version.
      Thank you!

    • @bibhidnepal6163
      @bibhidnepal6163  4 ปีที่แล้ว

      @@kennethtrotman It works on any office version, i can suggest to upgrade to latest.

    • @fahadsulaiman2912
      @fahadsulaiman2912 4 ปีที่แล้ว +1

      @@kennethtrotman for latest version
      (Ctrl+F9) -> (Ctrl+fun+F9)

    • @cesarsandino6436
      @cesarsandino6436 4 ปีที่แล้ว +1

      @@fahadsulaiman2912 you can also just type the curly brackets {}

  • @ImpudiaGames
    @ImpudiaGames 4 ปีที่แล้ว +3

    Thank you, this worked perfectly for me, Can you please explain the "IF True" and the "\d" in the end? I would just enjoy knowing what those are doing. Thank you very much again.

    • @bibhidnepal6163
      @bibhidnepal6163  4 ปีที่แล้ว +6

      If true is used to execute the remaining block only if the picture and path is available that help to prevent us from not getting error if there is error in path and pictures, and \d denotes end of line.

  •  3 ปีที่แล้ว +1

    Thank you! Works like a charm

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

    Hi, Thanks a ton for this tutorial and it worked like a charm. My requirement is to email customized birthday cards to staffs. I want the picture to be inserted in the mail body rather than add as an attachment. Also the email should go on the birthday dates at a specified time. Will you be able to help me ?

  • @stevebegin2489
    @stevebegin2489 2 ปีที่แล้ว

    Nice job! Thank you for the tutorial.

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

    Hello! Thanks, it worked. I need to rotate the image right and left though, how can I do it?

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

      You need to fix the image before adding them using other software.

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

      @@bibhidnepal6163 Ok, thanks

  • @canopusstore1624
    @canopusstore1624 3 ปีที่แล้ว +1

    Nice ITS work....but how to make the pic not move and alot of picture..not just 1?

  • @giuseppezattoni4664
    @giuseppezattoni4664 6 หลายเดือนก่อน

    Thanks. You#1

  • @dwaynee77
    @dwaynee77 4 ปีที่แล้ว +1

    Thanks, bro

  • @rebekahmalyon3883
    @rebekahmalyon3883 2 ปีที่แล้ว

    Hiya, what if you don't have a "fn" key on your keyboard and alt + F9 just bring up the menu shortcuts.. Tried just coping in the formula but it wont recognise it

  • @dulanjanarukshan5878
    @dulanjanarukshan5878 3 ปีที่แล้ว

    Very usefull. Thank you sir

  • @ohernand99
    @ohernand99 4 ปีที่แล้ว +1

    So useful!

  • @karenha9234
    @karenha9234 4 ปีที่แล้ว +2

    Hi Bibhid,
    Are the \\ for every \ that is in the path? or just the beginning and end? For example: C:\\Users\kha\Desktop\Roaring Reader Test\\ or C:\\Users\\kha\\Desktop\\Roaring Reader Test\\
    I can do everything except get the image to load. The image is a PNG so I am not sure if that has anything to do with it.

    • @cesarsandino6436
      @cesarsandino6436 4 ปีที่แล้ว +2

      Don't know why he had them in the first place, it might have been the way he copied. but you can just copy the full path and paste it on there and skip a lot of what he did. you can just put C:\Temp:\Pictures if that's where you put them and ignore the find and replace from \\ to \. but if you still wish to go your way, it's for every single one, Windows does not do \\.
      you truly need about 2 minutes of this video to accomplish the task, it was amazing. saved me hours since I had to do 500 QR Codes to match names.

    • @joannescott7914
      @joannescott7914 3 ปีที่แล้ว +1

      @@cesarsandino6436 thanks for the info

  • @kirtikanitkar5028
    @kirtikanitkar5028 3 ปีที่แล้ว

    Hi, I am using Mac Laptop and this works perfectly well, while in document, when I sent it via outlook though, the image is not visible and shows broken what might be the issue?

    • @bibhidnepal6163
      @bibhidnepal6163  3 ปีที่แล้ว +1

      you need to send the image as well and store it in the same folder as in your current pc

  • @knmacdonald1
    @knmacdonald1 2 ปีที่แล้ว

    Hello - THANKS for this information but it is not working on my MAC. How do I need to do it for a MAC from Excel to Word? I do not have an "E:" or "C:\\" drive. Mine simply has the name like "mbp-nm\\MAC SSD\\users\\..." Can you please help me? Thanks.

    • @bibhidnepal6163
      @bibhidnepal6163  2 ปีที่แล้ว

      Try using only single \ and also provide the path only after home folder \\pictures\\img

    • @knmacdonald1
      @knmacdonald1 2 ปีที่แล้ว

      @@bibhidnepal6163 THANKS for your reply. I have tried that but it's still not working. Could I just "insert field" INCLUDEPICTURE instead and link to Path? It seems like the photo is there but nothing displays. Any other options?

  • @joannescott7914
    @joannescott7914 3 ปีที่แล้ว +1

    Thanks for putting together this tutorial. The fields you put into the instructions above seem to have different spaces between them compared to the video. Which one is correct?
    As above: {INCLUDEPICTURE {IF TRUE "{MERGEFIELD Path }/{ MERGEFIELD Pics}"}\d}
    or the video: { INCLUDEPICTURE { IF TRUE"{MERGEFIELD Path }/{ MERGEFIELD Pics}" }\d }
    Please help!!!! There seems to be 5 different spaces between the 2 above.
    I have watched it so many times but still can't get mine to work like yours-the best I can do is one photo.

  • @PepeSi7via
    @PepeSi7via 2 ปีที่แล้ว

    Do you know how to keep photos oriented properly or keep them from turning on their side?

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

      I'd also like to know, I need my images to turn 90º! Please let me know in case you learned how to fix this. Thanks! :)

  • @angelahughes7790
    @angelahughes7790 2 ปีที่แล้ว

    Alt F9 is not giving me the braces. Do you have any suggestions?

    • @claireoliver1429
      @claireoliver1429 2 ปีที่แล้ว

      control F9 is the braces, alt F9 shows the merge field

  • @6833573
    @6833573 3 ปีที่แล้ว

    If possible, please share work book.

  • @abdussalamkk2448
    @abdussalamkk2448 3 ปีที่แล้ว

    As above: {INCLUDEPICTURE {IF TRUE "{MERGEFIELD Path }/{ MERGEFIELD Pics}"}\d}
    or the video: { INCLUDEPICTURE { IF TRUE"{MERGEFIELD Path }/{ MERGEFIELD Pics}" }\d }
    I tried both merge fields copied above. alas, not working used same titles too used path : C:\\Users\\Cosmos\\Desktop\\Downloads

    • @zahratul.aini.a
      @zahratul.aini.a 2 ปีที่แล้ว

      Add \\ in the last part of your path, like this C:\\Users\\Cosmos\\Desktop\\Downloads\\