Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2020, 07:44 PM
SQUiD SQUiD is offline Mail Merge - Multiple Sources Windows 10 Mail Merge - Multiple Sources Office 2019
Novice
Mail Merge - Multiple Sources
 
Join Date: Nov 2020
Posts: 6
SQUiD is on a distinguished road
Default

Thanks for the response, I've uploaded a copy of what the document will generally look like (excuse the existing merge fields).



The fields highlighted in yellow is the information that's being pulled from a m$ database query, whilst the fields highlighted in green is from excel.

The fields in both sources will never alter field names.

It'll only ever be generation of one letter at a time, at each time a request it placed, I'll look to create this merged letter.

-----------------------------------------------------------

The issue I'm experiencing with the database fields is its not recognising the source and returns an error, no valid result from table, the below is what I've worked out so far which is displaying results, however when I go to duplicate this elsewhere calling upon different fields, I experience issues.


Code:
{ DATABASE  \d "\\\\Nas\\xx\\Test\\External Plant Hire v2.1.accdb" \s "SELECT `EquipmenttMake`, `EquipmentModel`, `EquipmentYear`, `EquipmentRegistration` FROM `qryConfirmationOrderExport`" }

I was actually attempting to replicate your Incident document from that other thread :P
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge with 2 sources Marcia Mail Merge 3 07-04-2020 09:38 PM
Mail merge - data sources Sarki76 Mail Merge 2 09-02-2019 01:28 AM
Mail Merge - Multiple Sources Mail Merge Student Transcript - Multiple Years from multiple sheets aizah2018 Mail Merge 1 11-11-2018 01:27 AM
Choosing Mail Merge templates and excel Data Sources using drop downs dushan997 Mail Merge 3 08-04-2017 07:54 PM
Mail Merge to multiple employees in multiple locations as PDF by location GFiz Mail Merge 1 05-13-2017 08:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:32 PM.


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