Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-06-2020, 05:59 PM
Cib886 Cib886 is offline Variable Mail Merge to Email from Excel Windows 7 64bit Variable Mail Merge to Email from Excel Office 2010
Novice
Variable Mail Merge to Email from Excel
 
Join Date: Jan 2020
Posts: 1
Cib886 is on a distinguished road
Default Variable Mail Merge to Email from Excel

I am wanting to send an order confirmation email to our customers but it needs to have specific customer and order details in it.


below is a sample of what i need



Dear customer,


Your order has been processed, half your order will be dispatched from warehouse 1 and the other half from warehouse 2, please see details below,


Invoice 000001 will be shipped for warehouse 1 and contains the below item,


12584 black shoes
36548 white shirt
69745 white socks




Invoice 000002 will be shipped for warehouse 2 and contains the below item,


15789 white shoes
36558 Black shirt


the reds parts are what is pulled from Excel.


Problems i am having with this are

- all orders will differ in size and items.
- i can only get it to put the invoice number before each item
- i am unable to add an email signature as all orders differ in size


can anyone please help with this?


Last edited by Cib886; 01-06-2020 at 07:45 PM. Reason: Missed some information
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable Mail Merge to Email from Excel Mail Merge variable table length ajohnson Mail Merge 3 06-28-2018 06:39 AM
Variable Mail Merge to Email from Excel Mail merge with variable content from Excel jaggu Mail Merge 5 05-09-2017 02:00 PM
Variable Mail Merge to Email from Excel Mail Merge using variable data in Excel dewestone Mail Merge 1 12-20-2016 01:09 PM
Variable Mail Merge to Email from Excel Mail Merge with variable table length MS Word 2013 rbr Mail Merge 6 11-18-2016 07:05 AM
Variable Mail Merge to Email from Excel Mail merge at large table with variable number of rows blar Mail Merge 1 10-19-2015 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 AM.


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