Hi all,
I've been given some very complex Word documents with lots of graphics and text from the marketing department that they want to combine with a very involved fee page that is generated by Microsoft Access as one PDF. Which do you think seems to be the better option:

1. Recreate the Word document in Access. Pros: It will come out as one PDF. Cons: It's a really involved Word doc and graphics don't look that great on Access reports.

2. Use Access to control Word and import the data into the Word document and then use Word to export as PDF. Pros: looks better Cons: I don't know how to do it and I don't even know if I can control Word that way.

Thanks for your opinions.

musicloverlch laid this down on his screen :
> Hi all,
> I've been given some very complex Word documents with lots of graphics and
> text from the marketing department that they want to combine with a very
> involved fee page that is generated by Microsoft Access as one PDF. Which do
> you think seems to be the better option:
>
> 1. Recreate the Word document in Access. Pros: It will come out as one PDF.
> Cons: It's a really involved Word doc and graphics don't look that great on
> Access reports.
>
> 2. Use Access to control Word and import the data into the Word document and
> then use Word to export as PDF. Pros: looks better Cons: I don't know how to
> do it and I don't even know if I can control Word that way.
>
> Thanks for your opinions.

Or

3. Use Word to Import the Data from Access. Word like Excel and
Access has a full programmable VBA Layer sitting behind it. I also
have ZERO experience writing code behind a Word document, but I have to
admit it sounds like it might be an interesting endeavor. If it were
me I’d give myself a couple hours of research and coding to see if it
was feasible or not.

Rdub

It depends whether you want to control the whole lot from within your Access database or not.

If the latter then convert the Word document to pdf; create your fees pdf; and then use something like Adobe to merge the two pdfs into one.

If the former then Albert Kallal has produced a facility within Access to merge pdfs files:
https://groups.google.com/g/comp.databases.ms-access/c/RyFkucKupSU/m/7-uID4axAgAJ

I use this.

On Monday, 23 August 2021 at 17:03:16 UTC+1, musicloverlch wrote:
> Hi all,
> I've been given some very complex Word documents with lots of graphics and text from the marketing department that they want to combine with a very involved fee page that is generated by Microsoft Access as one PDF. Which do you think seems to be the better option:
>
> 1. Recreate the Word document in Access. Pros: It will come out as one PDF. Cons: It's a really involved Word doc and graphics don't look that great on Access reports.
>
> 2. Use Access to control Word and import the data into the Word document and then use Word to export as PDF. Pros: looks better Cons: I don't know how to do it and I don't even know if I can control Word that way.
>
> Thanks for your opinions.

On Monday, August 23, 2021 at 11:03:16 AM UTC-5, musicloverlch wrote:
> Hi all,
> I've been given some very complex Word documents with lots of graphics and text from the marketing department that they want to combine with a very involved fee page that is generated by Microsoft Access as one PDF. Which do you think seems to be the better option:
>
> 1. Recreate the Word document in Access. Pros: It will come out as one PDF. Cons: It's a really involved Word doc and graphics don't look that great on Access reports.
>
> 2. Use Access to control Word and import the data into the Word document and then use Word to export as PDF. Pros: looks better Cons: I don't know how to do it and I don't even know if I can control Word that way.
>
> Thanks for your opinions.

Have you tried mail merge from Word, using the query in Access generating the PDF?

Google "reference access query from word document", finds a number of pages..