William Hindman
wdhindman at dejpolsystems.com
Fri Apr 16 14:26:57 CDT 2010
...first things first ...there is no reason an image that looks fine in Word shouldn't look just as well in Access ...its probably missing a graphics filter which can usually be fixed just by setting a reference ...but if not, Lebans has some great graphics plug-in code that will do the job. ...the mail merge is as simple as pie ...but don't go there just yet. William -------------------------------------------------- From: "John Clark" <John.Clark at niagaracounty.com> Sent: Friday, April 16, 2010 2:23 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: [AccessD] Access to Word > Well, at the risk of repeating myself...if anyone remember my attempt to > do this, back in December...I have never created a form in Word and passed > to it, data from an Access DB...and now I have a need to do such a thing. > I "got around" this, back then, by actually creating the whole document as > an Access report, as I was guided to do, by several list members here. > This was fantastic advice, and it was great in that > circumstance...however, it just isn't in the cards on this project. > > I immediately tried doing this, but the header, of all things, prevents me > from going this way...the logo just looks awful, when done in > Access...don't know why, it just does. I don't have the time to do > anything w/this, and don't know if I could anyhow, so I'm going to go > ahead and try doing this w/Word. > > My 1st question...is a mail merge what I am looking at doing? I'm only > looking to create a single document at a time...a certificate...that I > will be using a query to gather. The user will enter information on a > student, and they will then print a certificate for that student. The > query choose one single student, based on the record currently active in > the form. > > I'm following instructions for a mail merge, but I get to a point where it > wants my list of "recipients." I don't really have this, I simply have > data, and I want to create one single document at a time, using this data. > > Am I barking up the wrong tree here? Should I be looking at something > else, or is it indeed a mail merge, that I am trying to do? > > Thanks ahead of time...J Clark > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >