Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Large Graphic "Mail Merge"
I prepare a 30 page report every week and it has 20-30 1600x1200
pictures in the document. I would love to be able to effectively do a mail merge with them. (E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes here.) What's the best way to do this? Thank you. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#2
|
|||
|
|||
Large Graphic "Mail Merge"
See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barry S." wrote in message ... I prepare a 30 page report every week and it has 20-30 1600x1200 pictures in the document. I would love to be able to effectively do a mail merge with them. (E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes here.) What's the best way to do this? Thank you. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#3
|
|||
|
|||
Large Graphic "Mail Merge"
Hi Barry
Barry S. wrote: I prepare a 30 page report every week and it has 20-30 1600x1200 pictures in the document. I would love to be able to effectively do a mail merge with them. (E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes here.) What's the best way to do this? It sounds like a MailMerge would not be the best way (at least it isn't straight-forward why you'd want to use one): my first idea would be to insert the pictures as links (positioned in table cells with fixed height/width). HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
#4
|
|||
|
|||
Large Graphic "Mail Merge"
On Mon, 24 Oct 2005 06:24:03 +0200, "Doug Robbins - Word MVP"
wrote: See the "Graphics from data base" item under the "Special merges" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm I'm reading it and I think I'm missing some things.. Like how the merge field in Word knows how to reference to a given Field in Access.. { IncludePicture "C:\\Data\\Pics\\{ Mergefield Signature \* upper }" } Is "Signature" The field in the Access Database? Thanks.. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#5
|
|||
|
|||
Large Graphic "Mail Merge"
On Mon, 24 Oct 2005 10:50:30 +0200, "Robert M. Franz (RMF)"
wrote: Hi Barry Barry S. wrote: I prepare a 30 page report every week and it has 20-30 1600x1200 pictures in the document. I would love to be able to effectively do a mail merge with them. (E.g. 1.JPG goes into a box with a box that knows that 1.JPG goes here.) What's the best way to do this? It sounds like a MailMerge would not be the best way (at least it isn't straight-forward why you'd want to use one): my first idea would be to insert the pictures as links (positioned in table cells with fixed height/width). HTH Robert Could you direct me to a further instruction on inserting pictures as links? Google doesn't seem to be directing me... Thanks. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#6
|
|||
|
|||
Large Graphic "Mail Merge"
Hi Barry
Barry S. wrote: On Mon, 24 Oct 2005 10:50:30 +0200, "Robert M. Franz (RMF)" wrote: Could you direct me to a further instruction on inserting pictures as links? Google doesn't seem to be directing me... What version of Word? In 2003 (and most probably in all three previous versions), I have a topic "Insert Picture" in the offline help. In there, click on "Insert a picture from a file", and also on "Show All". That's the base information (it doesn't really tell you _how_ to do it, though :-( ). The actual thing to do is: Insert | Picture | From File, locate the picture, and click on the small black triangle next to the "Insert" button. Use "Link". This results in an INCLUDEPICTURE-link (which you can see when you press SHIFT-F9 while the picture is selected. Now you can read up that field in Word's help, too. HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
#7
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On Tue, 25 Oct 2005 16:06:11 +0200, "Robert M. Franz (RMF)"
wrote: The actual thing to do is: Insert | Picture | From File, locate the picture, and click on the small black triangle next to the "Insert" button. Use "Link". This results in an INCLUDEPICTURE-link (which you can see when you press SHIFT-F9 while the picture is selected. Now you can read up that field in Word's help, too. Once I've got the picture in there and Shift-F9d it, I get: { INCLUDEPICTURE "M:\\test\\1.JPG" \d } When I manually update the text so 1 become 2 or 3 or 4.. It does not change the picture. (1, 2, 3, 4.JPG all exist.) Is there a way to manually change the link so it points to the correct file? Thanks. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#8
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
Are you pressing F9 to update the field after you edit it?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Barry S." wrote in message ... On Tue, 25 Oct 2005 16:06:11 +0200, "Robert M. Franz (RMF)" wrote: The actual thing to do is: Insert | Picture | From File, locate the picture, and click on the small black triangle next to the "Insert" button. Use "Link". This results in an INCLUDEPICTURE-link (which you can see when you press SHIFT-F9 while the picture is selected. Now you can read up that field in Word's help, too. Once I've got the picture in there and Shift-F9d it, I get: { INCLUDEPICTURE "M:\\test\\1.JPG" \d } When I manually update the text so 1 become 2 or 3 or 4.. It does not change the picture. (1, 2, 3, 4.JPG all exist.) Is there a way to manually change the link so it points to the correct file? Thanks. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#9
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On Wed, 23 Nov 2005 17:20:45 -0600, "Suzanne S. Barnhill"
wrote: Are you pressing F9 to update the field after you edit it? No, but that seems to help though.. Thank you. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#10
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On Wed, 23 Nov 2005 19:10:30 -0700, Barry S.
wrote: On Wed, 23 Nov 2005 17:20:45 -0600, "Suzanne S. Barnhill" wrote: Are you pressing F9 to update the field after you edit it? No, but that seems to help though.. Cool. I now have lots of includefile fields that update properly, but when the photos are inserted, it seems like the photos are being cropped/cut off. Is there a way to insert the photos without any cropping or unintended additional formatting? __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#11
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
Make sure the paragraph you're inserting them into doesn't have Exact line
spacing. If you want all the graphics to be the same height or width, put the field in a table cell. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Barry S." wrote in message ... On Wed, 23 Nov 2005 19:10:30 -0700, Barry S. wrote: On Wed, 23 Nov 2005 17:20:45 -0600, "Suzanne S. Barnhill" wrote: Are you pressing F9 to update the field after you edit it? No, but that seems to help though.. Cool. I now have lots of includefile fields that update properly, but when the photos are inserted, it seems like the photos are being cropped/cut off. Is there a way to insert the photos without any cropping or unintended additional formatting? __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#12
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On Wed, 23 Nov 2005 21:42:13 -0600, "Suzanne S. Barnhill"
wrote: Make sure the paragraph you're inserting them into doesn't have Exact line spacing. If you want all the graphics to be the same height or width, put the field in a table cell. They are going into two boxes.. 2 pictures Side by side. Initially 1 line high.. 1200x1600 format. When inserted directly in, they are fine. When inserted via includefile, they seem to take on a default sizing of their own. Is there a way to "force" them to fill a cell? __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#13
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
If a picture is smaller than the designated "box," I don't think there's any
way to make it larger. My experience was with shoehorning very large photos into smaller cells. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Barry S." wrote in message ... On Wed, 23 Nov 2005 21:42:13 -0600, "Suzanne S. Barnhill" wrote: Make sure the paragraph you're inserting them into doesn't have Exact line spacing. If you want all the graphics to be the same height or width, put the field in a table cell. They are going into two boxes.. 2 pictures Side by side. Initially 1 line high.. 1200x1600 format. When inserted directly in, they are fine. When inserted via includefile, they seem to take on a default sizing of their own. Is there a way to "force" them to fill a cell? __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#14
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On Thu, 24 Nov 2005 08:28:44 -0600, "Suzanne S. Barnhill"
wrote: If a picture is smaller than the designated "box," I don't think there's any way to make it larger. My experience was with shoehorning very large photos into smaller cells. No, the photo seems to take on some pre-designated default size when included as an include file field. When clicking on the box and then inserting a photo, it's fine. It's like using the field code is forcing some kind of formatting change. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#15
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
FWIW, the field code I'm using is this:
{ INCLUDEPICTURE "C:\\Documents and Settings\\Suzanne S. Barnhill\\My Documents\\My Pictures\\Rotary\\Member Photos\\{ IF { MERGEFIELD Photo } = "" "No Photo" "{ MERGEFIELD Photo }" }.JPG" \d } I'm inserting it into a table cell with exact height and preferred width. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Barry S." wrote in message ... On Thu, 24 Nov 2005 08:28:44 -0600, "Suzanne S. Barnhill" wrote: If a picture is smaller than the designated "box," I don't think there's any way to make it larger. My experience was with shoehorning very large photos into smaller cells. No, the photo seems to take on some pre-designated default size when included as an include file field. When clicking on the box and then inserting a photo, it's fine. It's like using the field code is forcing some kind of formatting change. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#16
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
It seems to just come in as default when linked.
You format the pic for desired size, but it seems to revert when you change the source or update it. Maybe use a quick VBA routine to update and resize the pics? here's my field contents: { INCLUDEPICTURE "C:\\Documents and Settings\\jm065225\\My Documents\\My Pictures\\1.bmp" \* MERGEFORMAT \d } Jay |
#17
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On 28 Nov 2005 09:15:00 -0800, "jay m" wrote:
It seems to just come in as default when linked. You format the pic for desired size, but it seems to revert when you change the source or update it. That sounds like what is happening. Maybe use a quick VBA routine to update and resize the pics? here's my field contents: Hmm, I only want them to resize to fill the table cell on a document that gets edited every week. I suspect it retains some sort of formatting when I do an insert picture, but I lose it when I try to do an IncludePicture.. I'm not looking to change the actual size of the picuture.. (Eg. Not go from 1600x1200 to 640x480) So the change is a formatting only change. Is there some sort of VBA script that will change the formatting only in the document? { INCLUDEPICTURE "C:\\Documents and Settings\\jm065225\\My Documents\\My Pictures\\1.bmp" \* MERGEFORMAT \d } Which is basically what I have.. __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#18
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
On Sat, 03 Dec 2005 21:05:53 -0700, Barry S.
wrote: On 28 Nov 2005 09:15:00 -0800, "jay m" wrote: It seems to just come in as default when linked. You format the pic for desired size, but it seems to revert when you change the source or update it. That sounds like what is happening. Decided to record some macros tonight to see what I had.. Sub Macro1() ' ' Macro1 Macro ' InlineShapes.AddPicture FileName:= _ "C:\test\test.JPG", LinkToFile:=True _ , SaveWithDocument:=True End Sub All desired formatting was retained.. Is there a way to type the VBA directly into a table cell? __________________ Note: To reply, replace the word 'spam' embedded in return address with 'mail'. |
#19
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Large Graphic "Mail Merge"
Check the Word MVPs FAQ-
I know you can create a button or other control linked to a macro. Maybe there's a better way. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using graphic w/mail merge | Mailmerge | |||
How can I print a graphic to the edge of the page? | Microsoft Word Help | |||
How do I print a graphic in a .doc file? | Microsoft Word Help | |||
Different graphic for each record | Mailmerge | |||
Unchecking 'different first page' in header removes graphic from first page | Page Layout |