Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2019, 02:15 AM
macropod's Avatar
macropod macropod is offline Multiple File Mailmerge Windows 7 64bit Multiple File Mailmerge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
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


You can attach files to a post here, via the paperclip symbol after clicking on 'Go Advanced' below the 'Quick Reply' panel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-07-2019, 09:00 AM
kevw1983 kevw1983 is offline Multiple File Mailmerge Windows 10 Multiple File Mailmerge Office 2019
Novice
Multiple File Mailmerge
 
Join Date: Apr 2019
Posts: 8
kevw1983 is on a distinguished road
Default

Hi Paul

thank you very much for looking at this for me, i have attached five files

word file - shows the place holders and field names from each of the original spreadsheet files

i have however used a vlookup formula to bring everything into one spreadsheet (combined file) in the hope that this would bring in the rent lines which need to go in the table on P2 and this is where i am stuck.

I will attach a PDF of how the finished letter should look
Attached Files
File Type: xlsx Aztec File 1.xlsx (10.4 KB, 8 views)
File Type: xlsx Aztec 2.xlsx (9.9 KB, 8 views)
File Type: xlsx Aztec 3.xlsx (18.0 KB, 8 views)
File Type: doc Aztec Letter Temp.doc (52.0 KB, 9 views)
File Type: xlsx Aztec Combined File.xlsx (35.2 KB, 9 views)
Reply With Quote
  #3  
Old 04-07-2019, 09:02 AM
kevw1983 kevw1983 is offline Multiple File Mailmerge Windows 10 Multiple File Mailmerge Office 2019
Novice
Multiple File Mailmerge
 
Join Date: Apr 2019
Posts: 8
kevw1983 is on a distinguished road
Default

as promised see attached finished pdf of how file will look
Attached Files
File Type: pdf Aztec Example 1.pdf (358.9 KB, 9 views)
Reply With Quote
  #4  
Old 04-08-2019, 09:23 AM
kevw1983 kevw1983 is offline Multiple File Mailmerge Windows 10 Multiple File Mailmerge Office 2019
Novice
Multiple File Mailmerge
 
Join Date: Apr 2019
Posts: 8
kevw1983 is on a distinguished road
Default

Hi Paul

real sorry to be a pest, just wondering how you are getting on with this if you have had a chance to look at it?

Kev
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple File Mailmerge MailMerge from txt file - failing when the file path contains a reserved SQL word travb81 Word VBA 7 10-26-2018 04:00 AM
Multiple File Mailmerge Mailmerge invoicing multiple items E__YU Mail Merge 3 01-24-2017 05:55 AM
Multiple File Mailmerge Trouble doing a Mailmerge in Word 2010 with multiple records for the same client Merlot Mail Merge 2 12-07-2015 10:13 AM
Mailmerge certain text using multiple if statements Debs Mail Merge 4 06-19-2014 03:34 AM
Multiple File Mailmerge Mailmerge to a table from a txt file troy23 Mail Merge 7 01-29-2014 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 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