Hi All,

Through excel, i am saving my outlook emails in word format and then i
send this mails saved in word to my suppliers. However, some people
came with issues, that they are not able to open the word file. so i
thought changing word into pdf will work.

with VBA code i am able to open the word file but dont know how to
convert it into pdf.

please help.

thanks,
navin

I'm not sure you can directly save Word documents to PDF without either
"printing" to PDF or converting them using Adobe Acrobat. Check into Acrobat
or PDF995 for more help there.

Otherwise, is formatting important? If not, how about saving to a text file?

HTH,
Matthew Pfluger

"navin" wrote:

Hi All,

Through excel, i am saving my outlook emails in word format and then i
send this mails saved in word to my suppliers. However, some people
came with issues, that they are not able to open the word file. so i
thought changing word into pdf will work.

with VBA code i am able to open the word file but dont know how to
convert it into pdf.

please help.

thanks,
navin

Or if you save as a Rich Text Format (RTF), Windows usually knows to open
using the "write" program if word is not associated with .rtf files. And you
should be able to save to .rtf as easily as word.

Look under the alltime section on the right:

http://www.excelguru.ca/
Ken Puls' site.

the approach would be to automate Word from Excel (or do the programming in
Word). You would use a technique similar to Ken's to open the documents and
print them using the PDF print driver. Here is some information on
automating an office application from another:


http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

--
Regards,
Tom Ogilvy




"navin" wrote:

Hi All,

Through excel, i am saving my outlook emails in word format and then i
send this mails saved in word to my suppliers. However, some people
came with issues, that they are not able to open the word file. so i
thought changing word into pdf will work.

with VBA code i am able to open the word file but dont know how to
convert it into pdf.

please help.

thanks,
navin

Yes, that would work. But if the user cannot use Word to open his .doc
files, I wonder if there will be problems opening .rtf files?

The only thing I can think of as to why they couldn't open Word files is
that there was a version conflict or they actually don't have Word. Did they
elaborate on that?

Matthew Pfluger

"Mike H." wrote:

Or if you save as a Rich Text Format (RTF), Windows usually knows to open
using the "write" program if word is not associated with .rtf files. And you
should be able to save to .rtf as easily as word.