Save a .docm file as .pdf and email .pdf as attachment

		Microsoft Office Forums > Microsoft Word > Word VBA
Save a .docm file as .pdf and email .pdf as attachment

02-19-2019, 01:21 PM

macropod

Windows 7 64bit Save a .docm file as .pdf and email .pdf as attachment

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Change:
.Attachments.Add Doc.FullName
to:
.Attachments.Add strFilename
or:
.Attachments.Add Split(Doc.FullName, ".doc")(0) & ".pdf"

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Email sends mailmerge file behind email rather than attachment	TLC1974	Mail Merge	2	07-22-2016 12:53 AM
VBL code for automatic attachment of file into email	DrLoveday1	Outlook	1	04-12-2013 05:36 AM
Command button - save in temp folder and send email with attachment	bigbird69	Word VBA	13	11-18-2012 10:06 PM
A newbie question: a must to save macro word file as .docm?	tinfanide	Word VBA	6	12-06-2011 03:02 PM
email as pdf attachment - subject line and attachment named after mail merge	Nexus	Mail Merge	12	04-13-2011 11:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:25 PM.