[AccessD] Access to Word

I agree with William.

We faced the same challenge about a year ago.

It took a bit of time to get the Access Report to look just right, but
once it was set up, the process was much simpler by using just Access
instead of bringing Word into the mix.

Brad 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Friday, April 16, 2010 2:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access to Word

...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
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.