![]() I am sorry I can't offer you a better solution - let me know if you have any further questions. Now you’ve successfully configured your Word document for a mail merge. The only alternative to achieve this outcome would be to programme the steps using VBA (Visual Basic for Applications) to interact with Word, Outlook and Excel. Click the Start Mail Merge button, then select E-mail Messages from the dropdown menu. So to summarise the mail merge feature in Word can send a message to the recipients on a mailing list but won't be able to attach anything to that email, or create a spreadsheet with the data on separate tabs. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work. The Word mail merge feature will handle creating a message and emailing it to multiple recipients but unfortunately wouldn't make the table B and attached and send for you.Ī pivot table could produce separate tabs based on a criteria (Using Report Filter and Show Report Filter Pages)Įxcel can create subtotalled information and format it so it appears on separate pages when printed (though stored on the same sheet) using the Data / Subtotal feature. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Finally we need to one of these sheets or the whole workbook to email recipients. Set up mail merge in Outlook In the Mail Merge Contacts dialog box, select the options that work best for you. If I understand the situation correctly we have a data source (table A) and would like this splitting into a workbook that has multiple sheets (Table B, pages 1 to 4). Start mail merge in Outlook With the contacts selected, go to the Home tab > Actions group, and click the Mail Merge button. Upload a CSV file from Excel, import from Salesforce, or manually add recipients. Import windows mail to thunderbird download - Stellar Merge Mailbox for Outlook - Technician 1.0.0. ![]() Reviewers felt that Outlook OST viewer meets the needs of their business better than Yet Another Mail Merge (YAMM). However, reviewers preferred the ease of administration with Outlook OST viewer. Thanks for your update although it sounds like something that Word will not be able to do. Sending a mail merge in Outlook is easy with Yesware Campaigns. When assessing the two solutions, reviewers found Yet Another Mail Merge (YAMM) easier to use, set up, and do business with overall. ![]() RE: mail merge info to send to manager on outlook
0 Comments
Leave a Reply. |