Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2015, 07:18 AM
Deeper Deeper is offline newb - need help automating catalogue production Windows 7 64bit newb - need help automating catalogue production Office 2010 32bit
Novice
newb - need help automating catalogue production
 
Join Date: Sep 2015
Posts: 2
Deeper is on a distinguished road
Default newb - need help automating catalogue production

hi, sorry I'm new, been searching for 4 hours.

i need to produce a catalogue for an auction. the software i use can export four fields of information (lot number, description, estimated price, and a picture of the object) for each of up to 500 lots. i can export this information in various formats EG: Excell 97-2003 or Rich Text Format or several others.
when i open those exported files the fields are arranged in a simple row from left to right for each auction lot and a new row for each lot. Thats not how i want the catalogue laid out.
Is it possible for me to define a specific layout for the information and have Office open the exported file and automatically display it according to my definition. (I'm not sure if I'm asking the right question)

I'm not sure which would be the best piece of software to do this?



i will want it to look like this


photo_00001.jpg

your advice would be much appreciated i've spent a about 4 hour reading and searching for the best way to do this and some of the terminology is quite opaque to me. it seems like something that should be easy but as i look into it it is seeming more involved than i had imagined. how should i go about my task? speaking roughly or in detail.
thanks for any help
Reply With Quote
  #2  
Old 09-05-2015, 11:23 PM
macropod's Avatar
macropod macropod is offline newb - need help automating catalogue production Windows 7 64bit newb - need help automating catalogue production Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your page layout is suggestive of a snaking two-column page setup with a two-column table that has fixed column widths equal to about half the page column width. Depending on what you're using for a data source (Excel would do fine) and how the images can be both identified and located from it, it's quite possible the catalogue could be constructed using a Word mailmerge. Without more specific knowledge of what you're working with, though, it's impossible to say for sure.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-09-2015, 01:45 AM
Deeper Deeper is offline newb - need help automating catalogue production Windows 7 64bit newb - need help automating catalogue production Office 2010 32bit
Novice
newb - need help automating catalogue production
 
Join Date: Sep 2015
Posts: 2
Deeper is on a distinguished road
Default

Thanks for your reply Macropod. I will try to investigate the mailmerge possibilities
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
newb - need help automating catalogue production Motion path animation required for a production simulation anuru PowerPoint 4 08-09-2014 03:49 AM
newb - need help automating catalogue production How to Create a Product Catalogue lorr1e1 Word 1 08-04-2014 08:10 AM
NEWB to Macros - formatting exports EC37 Excel Programming 52 06-25-2014 06:26 AM
Catalogue e-mail merge problem lol22 Mail Merge 4 02-15-2013 02:59 AM
newb - need help automating catalogue production photo plate production phycobob Drawing and Graphics 1 02-15-2012 09:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:55 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