Insert picture and save macro

  • Thread starter Thread starter Boss
  • Start date Start date
B

Boss

I am looking for a macro code which can do the foll task

First it should insert picture in a word file, picture .gif file is in local
disk.

Second it should write the details of the picture which is available in an
excel sheet

Third it should save the file with a file name again the filename is
available in excel sheet.

I have to do the same for about 500 times.

Now i am using mail merger and i manually inserting picture.

Hope this is not too tuff for u all experts.

Lots & lots of thanks in advance
Boss
 
This is great.. Thanks

But how do i save the file.. the file name is also in the excel sheet.

I saw the code of saveing file at two location but filename is a problem..

Thanks
Boss
 
Thanks for the update, but actually it does not serves me purpose. What I
wish to do is to first mail merging the image (Which i am successful) then i
wish to save the file then i go to the next record which gives me the next
picture and i again save it.
All i wish to do is to save the file word with a specific filename which is
available in the excel sheet.

Any ideas & help is appreciated.
Thanks
Boss
 
I think you are missing the point. If the filename of the picture and the
filename of the document are in the Excel data file, then you can merge the
whole lot to separate named files each with their own version of the picture
in one operation using the add-in to create the separate files?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
I will try it out.. when u say it can be done then i will do it.. many thanks
Boss
 
Hi,

i am faicing yet another issue, The files which are prepared after the mail
merge are not in print format form. I tried to change th tempplate but it
didn't worked.
Please help
Thanks
Boss
 
The add-in uses your normal.dot template and should produce documents in the
view saved in that template
See - http://word.mvps.org/FAQs/General/SaveViewAndZoom.htm
or
You can also control the view with auto macros in normal.dot.

See http://www.gmayor.com/installing_macro.htm

Sub AutoNew()
ActiveWindow.View.Type = wdPrintView
End Sub

Sub AutoOpen()
ActiveWindow.Caption = ActiveDocument.FullName
ActiveWindow.View.Type = wdPrintView
End Sub

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Thanks a lot for ur help.. u have really helped me inthis project... i ahve
done with the entire project which will save lot of man-hrs for the team..

Thanks a lot, with new wishes
Boss
 
You are welcome :)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help Inserting Multiple Pictures Into Word 0
Macro to insert picture from specific folder 0
inserting pictures in word 6
How can I change default for inserting a picture 2
inserting a picture 3
Macro to insert pictures in comments 8
inserted pictures do not print or display 1
unwanted border appear on 2 sides of inserted pictures 6

Back
Top