Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 10-04-2012, 02:48 PM
JohnFinNC JohnFinNC is offline Pictorial directory using mailmerge Windows XP Pictorial directory using mailmerge Office 2003
Novice
Pictorial directory using mailmerge
 
Join Date: Sep 2012
Location: North carolina
Posts: 6
JohnFinNC is on a distinguished road
Default Why all the "IF" statements?

Paul, your last response wasn't too helpful. I had already set up my database with fields for the jpg filename ( hence {MERGEFIELD "Filename"} ) and for the combined path and filename ( hence {MERGEFIELD "Picture"} ). I believe had already handled path and filename correctly.

The only method which works for me is a two-step process:

1. Position the insertion point and do "Insert Picture from File", except complete using the insert "Link to file" option. The result is like { INCLUDEPICTURE "DirectoryPhotos/Abels_Jon_1011_DSCF2804r.jpg" \* MERGEFORMAT \d }.

2.Next, replace the actual filename with the filename field, hence { INCLUDEPICTURE "DirectoryPhotos/{Mergefield "Filename"}" \* MERGEFORMAT \d }.

That said, I did implement your code, but with the two-step method above.

My template has twenty pictures on a page, so it resembles a sheet of labels. When I execute "Merge to New Document", I get six pages containing my 113 pictures. The only frustration is that the seven photos on the bottom of page five are repeated on the bottom of page six.

So...What are the purposes for your IF staements?

Thanks!


John

My template
Reply With Quote
 

Tags
includepicture, mailmerge field



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pictorial directory using mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
Pictorial directory using mailmerge question in pictorial representation gsrikanth Excel 1 03-02-2012 11:45 AM
Pictorial directory using mailmerge Directory Mailmerge rohitjain80 Mail Merge 1 02-12-2012 03:42 AM
Active Directory ababc Misc 0 09-19-2006 06:18 AM
Active Directory nukkumatti Misc 0 11-16-2005 08:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.


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