Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2023, 01:30 PM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default Mail Merge document shows the same picture on each document

I created an MS Word document with MS Word 2021. Knowing that Mailmerge doesn't work too well with the newer version, I did my text layout (ID #, Name, Phone, etc) and saved the document with a ".doc" extension. I then went to my "Mailmerge" tab and started the mailmerge process. I added my recipient list created in Excel. There is a column that has ".jpg" photos. I want to create the document as an Email document with each document including the members profile along with their photo.



The way I created the code for the photo was to use the "Input", "Pictures", find the pictures folder and choose one of the pictures. In lieu of clicking insert, I used the "Link to file". I named the "INCLUDE" name as "Image". I then hilighted the "Image" word and went to Mailings and inserted a Mergefield (Picture).

After the Alt+F9's and CTR+A and then F9's, I see the photo I used. To make the photo change with each document, I read that once you finish final merging, you click CTRL+A and then F9 again and then the photos were supposed to change to each photo for each record.

However, that doesn't work. I keep seeing the same photo on each record.

Can someone please help me? Thank you!
Reply With Quote
  #2  
Old 12-02-2023, 03:33 PM
Charles Kenyon Charles Kenyon is offline Mail Merge document shows the same picture on each document Windows 11 Mail Merge document shows the same picture on each document Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,053
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Mail Merge works just as well with the new system.
See Mail merge graphics by Graham Mayor, MVP.
Reply With Quote
  #3  
Old 12-03-2023, 09:05 AM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default

I am still having the problem.

Let me say what I am exactly trying to do. I want to build an email to all my members with their profile (Name, Badge #, phone #, photo, etc. I create the basic wording, I start the mail merge, click on the recipients and insert the field names.

To insert the picture, I have tried "Insert", "Pictures", the picture I want and in lieu of clicking "Insert" that picture, I click on "Link to file". I then go into that statement and hilight the just picture name (e.g., 007.jpg) leaving the ".jpg" unhighlighted and click on "Insert Fieldname" and click the field name (in my case, Picture).

The picture appears when I finish the merge, however, when I click "CTRL" + "A" and then click "F9", the same picture that I originally clicked on appears on all records.
Reply With Quote
  #4  
Old 12-03-2023, 10:55 AM
Charles Kenyon Charles Kenyon is offline Mail Merge document shows the same picture on each document Windows 11 Mail Merge document shows the same picture on each document Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,053
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You need the file name for each picture as part of your data file, a different file name for each record, perhaps. Read Graham's article.
You would have an IncludePicture Field in your primary merge document with the merge field identifying the picture file as the filename in the IncludePicture Field.
Reply With Quote
  #5  
Old 12-04-2023, 08:16 AM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default

Still having trouble with emailing member profiles that includes their photo. I downloaded the Graham Mayer "Mail Merge with Graphics" Add-In and the Graham Mayer "Mail Merge Graphics" detail, read both articles and loaded the Add-In into MS Word 2021.

I then created another document, started the mail merge as an email document and inserted the Mergefield items. I clicked where I wanted to load the photo and clicked on "Insert Graphics Merge Field" (the Graham Mayer Add-In). I clicked on the picture I wanted and clicked on "Complete Graphics Merge" (again the Graham Mayer Add-In).

I immediately got an error code. (See attachment)
Attached Images
File Type: jpg Graham Mayer.jpg (20.2 KB, 19 views)
Reply With Quote
  #6  
Old 12-04-2023, 10:18 AM
Charles Kenyon Charles Kenyon is offline Mail Merge document shows the same picture on each document Windows 11 Mail Merge document shows the same picture on each document Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,053
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You may need to use Doug Robbins' Merge Tools, which should work with the same files. MergeTools Add-In Page (Doug Robbins, MVP)
Reply With Quote
  #7  
Old 12-05-2023, 06:14 PM
zpy2 zpy2 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

Quote:
Originally Posted by clrockwell15 View Post
I created an MS Word document with MS Word 2021. Knowing that Mailmerge doesn't work too well with the newer version, I did my text layout (ID #, Name, Phone, etc) and saved the document with a ".doc" extension. I then went to my "Mailmerge" tab and started the mailmerge process. I added my recipient list created in Excel. There is a column that has ".jpg" photos. I want to create the document as an Email document with each document including the members profile along with their photo.

The way I created the code for the photo was to use the "Input", "Pictures", find the pictures folder and choose one of the pictures. In lieu of clicking insert, I used the "Link to file". I named the "INCLUDE" name as "Image". I then hilighted the "Image" word and went to Mailings and inserted a Mergefield (Picture).

After the Alt+F9's and CTR+A and then F9's, I see the photo I used. To make the photo change with each document, I read that once you finish final merging, you click CTRL+A and then F9 again and then the photos were supposed to change to each photo for each record.

However, that doesn't work. I keep seeing the same photo on each record.

Can someone please help me? Thank you!
There is a column that has ".jpg" photos. I want to create the document as an Email document with each document including the members profile along with their photo.

How about create html files which maybe easier to handle image?
Reply With Quote
  #8  
Old 12-07-2023, 10:25 AM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default

What I have done is go thru the Mail Merge Process and created PDF files showing the results of each procedure. I then put all those PDF files together into one PDF file. I have attached that PDF file to this email.

I believe I'm doing everything correctly, but I think I'm missing some little link within that process. Maybe someone can help me!
Attached Files
File Type: pdf My Merge Predicament.pdf (175.4 KB, 3 views)
Reply With Quote
  #9  
Old 12-07-2023, 03:47 PM
zpy2 zpy2 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

Quote:
Originally Posted by clrockwell15 View Post
What I have done is go thru the Mail Merge Process and created PDF files showing the results of each procedure. I then put all those PDF files together into one PDF file. I have attached that PDF file to this email.

I believe I'm doing everything correctly, but I think I'm missing some little link within that process. Maybe someone can help me!
Switches
\c Converter
Identifies the graphics filter you want to use. Use the file name of the graphics filter without the .flt file name extension; for example, type pictim32 for the Pictim32.flt filter.

I do not know if this parameter makes sense.

what kind of image file do you want to insert?
Reply With Quote
  #10  
Old 12-08-2023, 06:38 AM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default

How do i determine "graphic filter". I am using photos that were color photos, but I converted them to "gray scale 8 bit". All my photos have the file name extension of ".jpg".
Reply With Quote
  #11  
Old 12-08-2023, 06:50 AM
Italophile Italophile is offline Mail Merge document shows the same picture on each document Windows 11 Mail Merge document shows the same picture on each document Office 2021
Expert
 
Join Date: Mar 2022
Posts: 289
Italophile is a jewel in the roughItalophile is a jewel in the roughItalophile is a jewel in the roughItalophile is a jewel in the rough
Default

Quote:
Originally Posted by clrockwell15 View Post
What I have done is go thru the Mail Merge Process and created PDF files showing the results of each procedure. I then put all those PDF files together into one PDF file. I have attached that PDF file to this email.

I believe I'm doing everything correctly, but I think I'm missing some little link within that process. Maybe someone can help me!
Look carefully at the file path in your Excel worksheet. The problem should be obvious to you.
Reply With Quote
  #12  
Old 12-08-2023, 07:26 AM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default

Okay, maybe I'm stupid. Can you give me a clue?
Reply With Quote
  #13  
Old 12-08-2023, 08:08 AM
Italophile Italophile is offline Mail Merge document shows the same picture on each document Windows 11 Mail Merge document shows the same picture on each document Office 2021
Expert
 
Join Date: Mar 2022
Posts: 289
Italophile is a jewel in the roughItalophile is a jewel in the roughItalophile is a jewel in the roughItalophile is a jewel in the rough
Default

Quote:
Originally Posted by clrockwell15 View Post
Okay, maybe I'm stupid. Can you give me a clue?
File paths usually only have single path separators, e.g.: C:\Users\clroc\Documents\etc
not double as you have in your Excel file.
Reply With Quote
  #14  
Old 12-09-2023, 12:44 PM
clrockwell15 clrockwell15 is offline Mail Merge document shows the same picture on each document Windows 10 Mail Merge document shows the same picture on each document Office 2016
Novice
Mail Merge document shows the same picture on each document
 
Join Date: Aug 2018
Posts: 9
clrockwell15 is on a distinguished road
Default

Okay, folks! I finally got my email messages with photos working. I found a Mail Merge software add-in for MS Word called "OnMerge". It works beautifully. If anyone else needs the software and how to work it, let me know. It took a while to figure it out, but once I did, it works like a breeze.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge document shows the same picture on each document Mail Merge Document Stillgate Mail Merge 3 08-09-2018 03:03 PM
Mail Merge document shows the same picture on each document Help Sending Mail Merge Document dazwm Mail Merge 8 01-28-2014 01:00 PM
Mail Merge document shows the same picture on each document Formatting in mail merge document OnTheCouch Mail Merge 1 09-29-2013 07:05 PM
Mail Merge document shows the same picture on each document Mail Merge Doubles My Document ExecAssist Mail Merge 1 02-27-2012 04:06 PM
Mail Merge document shows the same picture on each document Need some help with building a mail merge document. DaveBF Mail Merge 1 09-22-2011 06:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft