Использование Excel в качестве источника изображений для мастера слияния Word

%3CLINGO-SUB%20id%3D%22lingo-sub-3086482%22%20slang%3D%22en-US%22%3E%D0%98%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5%20Excel%20%D0%B2%20%D0%BA%D0%B0%D1%87%D0%B5%D1%81%D1%82%D0%B2%D0%B5%20%D0%B8%D1%81%D1%82%D0%BE%D1%87%D0%BD%D0%B8%D0%BA%D0%B0%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%BC%D0%B0%D1%81%D1%82%D0%B5%D1%80%D0%B0%20%D1%81%D0%BB%D0%B8%D1%8F%D0%BD%D0%B8%D1%8F%20Word%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086482%22%20slang%3D%22en-US%22%3E%D0%92%D0%BE%D0%B7%D0%BC%D0%BE%D0%B6%D0%BD%D0%B0%20%D0%BB%D0%B8%20%D0%B2%20%D1%80%D0%B5%D0%B6%D0%B8%D0%BC%D0%B5%20%C2%AB%D0%BC%D0%B0%D1%81%D1%82%D0%B5%D1%80%20%D1%81%D0%BB%D0%B8%D1%8F%D0%BD%D0%B8%D1%8F%20Word%C2%BB%20%D0%B2%D1%81%D1%82%D0%B0%D0%B2%D0%BA%D0%B0%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9%2C%20%D1%81%D1%81%D1%8B%D0%BB%D0%BA%D0%B8%20%D0%BD%D0%B0%20%D0%BA%D0%BE%D1%82%D0%BE%D1%80%D1%8B%D0%B5%20(%D0%BF%D1%83%D1%82%D0%B8%20%D0%BA%20%D1%84%D0%B0%D0%B9%D0%BB%D0%B0%D0%BC%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9)%20%D0%BD%D0%B0%D1%85%D0%BE%D0%B4%D1%8F%D1%82%D1%81%D1%8F%20%D0%B2%20%D0%B1%D0%B0%D0%B7%D0%B5%20%D0%BF%D0%BE%D0%BB%D1%83%D1%87%D0%B0%D1%82%D0%B5%D0%BB%D0%B5%D0%B9%20%D0%B2%20%D1%84%D0%B0%D0%B9%D0%BB%D0%B5%20Excel%3F%20%D0%AF%20%D0%BF%D1%80%D0%BE%D0%B1%D0%BE%D0%B2%D0%B0%D0%BB%20%D0%B4%D0%B2%D0%B0%20%D0%B2%D0%B0%D1%80%D0%B8%D0%B0%D0%BD%D1%82%D0%B0%3A%3CBR%20%2F%3E%D0%92%D0%B0%D1%80%D0%B8%D0%B0%D0%BD%D1%82%201.%20%D0%9F%D1%83%D1%82%D1%8C%20%D0%BA%20%D1%84%D0%B0%D0%B9%D0%BB%D0%B0%D0%BC%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%BD%D0%B0%D1%85%D0%BE%D0%B4%D0%B8%D1%82%D1%81%D1%8F%20%D0%B2%20%D1%82%D0%B0%D0%B1%D0%BB%D0%B8%D1%86%D0%B5%20Excel%20%D0%B2%20%D1%81%D1%82%D0%BE%D0%BB%D0%B1%D1%86%D0%B5%20%D1%81%20%D0%B8%D0%BC%D0%B5%D0%BD%D0%B5%D0%BC%20%C2%AB%D0%98%D0%BC%D1%8F%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D1%8F%C2%BB%3CBR%20%2F%3E%C2%ABD%3A%5C%5Cpapka%201%5C%5Cpapka%202%20...%5C%5Cpapka%20N%20image.jpg%C2%BB%3CBR%20%2F%3E%D0%92%20%D1%88%D0%B0%D0%B1%D0%BB%D0%BE%D0%BD%D0%B5%20Word%20%7B%20INCLUDEPICTURE%20%7B%20MERGEFIELD%20%C2%AB%20%C2%ABName%20Image%C2%BB%20%7D%20%5C*%20MERGEFORMAT%7D%3CBR%20%2F%3E%3CBR%20%2F%3E%D0%92%D0%B0%D1%80%D0%B8%D0%B0%D0%BD%D1%82%202.%20%D0%92%20%D0%BF%D0%BE%D0%BB%D1%8F%D1%85%20Excel%20%D0%BD%D0%B0%D1%85%D0%BE%D0%B4%D1%8F%D1%82%D1%81%D1%8F%20%D1%82%D0%BE%D0%BB%D1%8C%D0%BA%D0%BE%20%D0%B8%D0%BC%D0%B5%D0%BD%D0%B0%20%D1%84%D0%B0%D0%B9%D0%BB%D0%BE%D0%B2%2C%20%D0%B0%20%D0%BF%D1%83%D1%82%D1%8C%20%D0%BA%20%D1%84%D0%B0%D0%B9%D0%BB%D0%B0%D0%BC%20%D0%B7%D0%B0%D0%BF%D0%B8%D1%81%D0%B0%D0%BD%20%D0%B2%20%D1%88%D0%B0%D0%B1%D0%BB%D0%BE%D0%BD%20Word.%3CBR%20%2F%3E%D0%92%20%D0%BE%D0%B1%D0%BE%D0%B8%D1%85%20%D0%B2%D0%B0%D1%80%D0%B8%D0%B0%D0%BD%D1%82%D0%B0%D1%85%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5%20%D0%B2%20%D1%80%D0%B5%D0%B7%D1%83%D0%BB%D1%8C%D1%82%D0%B0%D1%82%D0%B5%20%D1%81%D0%BB%D0%B8%D1%8F%D0%BD%D0%B8%D1%8F%20%D0%BD%D0%B5%20%D0%B7%D0%B0%D0%B3%D1%80%D1%83%D0%B6%D0%B0%D0%B5%D1%82%D1%81%D1%8F.%3CBR%20%2F%3E%D0%93%D0%B4%D0%B5%20%D0%BC%D0%BE%D1%8F%20%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%B0%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3086482%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3089147%22%20slang%3D%22en-US%22%3ERe%3A%20%D0%98%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5%20Excel%20%D0%B2%20%D0%BA%D0%B0%D1%87%D0%B5%D1%81%D1%82%D0%B2%D0%B5%20%D0%B8%D1%81%D1%82%D0%BE%D1%87%D0%BD%D0%B8%D0%BA%D0%B0%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%BC%D0%B0%D1%81%D1%82%D0%B5%D1%80%D0%B0%20%D1%81%D0%BB%D0%B8%D1%8F%D0%BD%D0%B8%D1%8F%20Word%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3089147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1290955%22%20target%3D%22_blank%22%3E%40AlexBondEr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20select%20the%20merged%20document%20and%20press%20F9%20to%20update%20the%20result%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.msofficeforums.com%2Fmail-merge%2F21803-mailmerge-tips-tricks.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMailmerge%20Tips%20%26amp%3B%20Tricks%3C%2FA%3E%2C%20in%20particular%20the%20section%20%3CSTRONG%3EManaging%20Mailmerge%20Graphics%3C%2FSTRONG%3E%20for%20some%20workarounds.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Возможна ли в режиме «мастер слияния Word» вставка изображений, ссылки на которые (пути к файлам изображений) находятся в базе получателей в файле Excel? Я пробовал два варианта:
Вариант 1. Путь к файлам изображений находится в таблице Excel в столбце с именем «Имя изображения»
«D:\\papka 1\\papka 2 ...\\papka N image.jpg»
В шаблоне Word { INCLUDEPICTURE { MERGEFIELD « «Name Image» } \* MERGEFORMAT}

Вариант 2. В полях Excel находятся только имена файлов, а путь к файлам записан в шаблон Word.
В обоих вариантах изображение в результате слияния не загружается.
Где моя ошибка?
1 Reply

@AlexBondEr 

You have to select the merged document and press F9 to update the result

See Mailmerge Tips & Tricks, in particular the section Managing Mailmerge Graphics for some workarounds.