Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2018, 11:27 AM
cam4mia cam4mia is offline Used Directory to create individual PDF reports... Now I need to attach/email them somehow Mac OS X Used Directory to create individual PDF reports... Now I need to attach/email them somehow Office 2016 for Mac
Novice
Used Directory to create individual PDF reports... Now I need to attach/email them somehow
 
Join Date: Feb 2018
Posts: 2
cam4mia is on a distinguished road
Unhappy Used Directory to create individual PDF reports... Now I need to attach/email them somehow

Hi all,



I used a Directory merge to create reports for each of my salesmen (100+), showing their itemized sales. Initially, my super wanted me to separate them by market (easy via filter) and email the PDF's to two branch managers.

Now he wants me to personally send the individual PDF's to each salesman... So here's what I have to work with:

I have a separate xls with matching names/emails, perhaps I could somehow get word or outlook to merge/attach based on name in PDF? Maybe I'll need VBA (I'm VERY inexperienced with VBA fyi...)? Ideas welcome... I'm okay with an extensive setup, I just need it to be quick for future use as I'll be sending these weekly.
Reply With Quote
  #2  
Old 02-07-2018, 02:43 PM
macropod's Avatar
macropod macropod is offline Used Directory to create individual PDF reports... Now I need to attach/email them somehow Windows 7 64bit Used Directory to create individual PDF reports... Now I need to attach/email them somehow Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For that, you may want to try one of the Many-to-One Mail Merge add-ins, available from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-02-2018, 01:47 PM
cam4mia cam4mia is offline Used Directory to create individual PDF reports... Now I need to attach/email them somehow Mac OS X Used Directory to create individual PDF reports... Now I need to attach/email them somehow Office 2016 for Mac
Novice
Used Directory to create individual PDF reports... Now I need to attach/email them somehow
 
Join Date: Feb 2018
Posts: 2
cam4mia is on a distinguished road
Default

Unfortunately, I'm on a Macbook so I'm unable to use Gmayor's add-on. Is Doug Robbins' compatible?
Reply With Quote
  #4  
Old 04-02-2018, 02:32 PM
macropod's Avatar
macropod macropod is offline Used Directory to create individual PDF reports... Now I need to attach/email them somehow Windows 7 64bit Used Directory to create individual PDF reports... Now I need to attach/email them somehow Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I don't believe either of those addins works on a Mac and I'm not aware of any Mac-compatible macros (which is what would be required) for doing this.

If its OK to send the report in the body of the email instead of as an attachment to it, and you have a separate worksheet or workbook with a list of the salesmen, you could use a DATABASE field in a normal ‘email’ mailmerge main document (I'm assuming DATABASE fields work on Macs). An outline of this approach can be found in my reply at: https://answers.microsoft.com/en-us/...f-8642e46fa103
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
directory, individual, reports

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to create a button to attach the active word doc to an email as a PDF without using Outlook TAKMalcolm Word VBA 1 09-21-2017 01:52 AM
Used Directory to create individual PDF reports... Now I need to attach/email them somehow Individual Reports Not Being Saved Properly JennEx Mail Merge 12 06-22-2016 03:01 PM
File Not Found error when trying to attach Word document to email Kimber Word 0 03-06-2015 06:47 PM
Word7 VBA- need userform screenshot to attach to email PANTECH Word VBA 5 06-02-2014 05:27 AM
Used Directory to create individual PDF reports... Now I need to attach/email them somehow Having Touble Finding Word File When Trying to Attach to Email freetibet213 Word 3 12-28-2011 05:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft