Anyone have any pointers on this?

I get query results in Excel format that I can fashion into a merge source
for mailing labels. I have worbook that prompts the user for the raw file
and generates a new, single sheet workbook with the merge data.

I'd like any help you might offer re: the code to call MS Word to generate
mailing labels using that data source, print them, close Word w/o saving and
return to the Excel file.

I have the code to call & close Word. from Excel. I have the Word code to
create the labels. I can't seem to combine them.

Thanks in advance

Hi Bill,

Can you post the codes that you are using so we can have a look?

Greg


Bill G wrote:
> Anyone have any pointers on this?
>
> I get query results in Excel format that I can fashion into a merge source
> for mailing labels. I have worbook that prompts the user for the raw file
> and generates a new, single sheet workbook with the merge data.
>
> I'd like any help you might offer re: the code to call MS Word to generate
> mailing labels using that data source, print them, close Word w/o saving and
> return to the Excel file.
>
> I have the code to call & close Word. from Excel. I have the Word code to
> create the labels. I can't seem to combine them.
>
> Thanks in advance