Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Problem: MailMerge Letter with Some Blank Fields
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2023, 02:54 AM
SallyDee SallyDee is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2016
Novice
Problem: MailMerge Letter with Some Blank Fields 		 
Join Date: Sep 2023
Posts: 4
SallyDee is on a distinguished road
Default Problem: MailMerge Letter with Some Blank Fields
Hello.
I have an Excel spreadsheet populated with text, numbers, dates etc.
I have settings adjusted to check conversion on opening, and choose DDE.
I have one particular field form the spreadsheet that continues to display the incorrect cell reference previewing results in the MailMerge letter in Ms Word. It seems to be reading from the cell adjacent, one column before in the spreadsheet.
Instead of just moving 1 column over, i'd like to know how to fix this

Thanks in advance



Regards,
Sally
Attached Images
File Type: png Spreadsheet.PNG (39.4 KB, 12 views)
File Type: png no preview.PNG (6.2 KB, 12 views)
File Type: png preview.PNG (4.4 KB, 12 views)
Reply With Quote
  #2  
Old 09-08-2023, 06:15 AM
gmayor's Avatar
gmayor gmayor is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Without access to the samples úsed it is difficult to ascertain what the issue is caused by, but my guess would be the DDE connection. DDE is notoriously flaky and best avoided. I would start by using the default connection.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-08-2023, 06:24 AM
SallyDee SallyDee is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2016
Novice
Problem: MailMerge Letter with Some Blank Fields 		 
Join Date: Sep 2023
Posts: 4
SallyDee is on a distinguished road
Default
Quote:
Originally Posted by gmayor View Post
Without access to the samples úsed it is difficult to ascertain what the issue is caused by, but my guess would be the DDE connection. DDE is notoriously flaky and best avoided. I would start by using the default connection.
Hi Graham - without the DDE connection, the dates display incorrectly. I tried all of the workarounds i could find online for correcting date format, but the only thing that worked was to use the DDE connection, however it threw out another issue.
Thanks for your input.
Regards,
Sally
Reply With Quote
  #4  
Old 09-08-2023, 09:14 AM
gmayor's Avatar
gmayor gmayor is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Use a formatting switch on the date field to achieve the format you require - see Formatting fields with switches
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 09-11-2023, 01:56 AM
SallyDee SallyDee is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2016
Novice
Problem: MailMerge Letter with Some Blank Fields 		 
Join Date: Sep 2023
Posts: 4
SallyDee is on a distinguished road
Default Mail Merge fields
Quote:
Originally Posted by gmayor View Post
Without access to the samples úsed it is difficult to ascertain what the issue is caused by, but my guess would be the DDE connection. DDE is notoriously flaky and best avoided. I would start by using the default connection.
Hi Graham,

Please find the excel spreadsheet & word mail merge doc attached - would appreciate if you could advise on the best route to take.

thank you
Sally
Attached Files
File Type: xlsx Letters MM July23.xlsx (14.5 KB, 5 views)
File Type: doc Word doc test.doc (30.0 KB, 2 views)
Reply With Quote
  #6  
Old 09-11-2023, 03:22 AM
gmayor's Avatar
gmayor gmayor is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
See attached
Attached Files
File Type: doc Word doc test.doc (31.0 KB, 2 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #7  
Old 09-11-2023, 03:46 AM
SallyDee SallyDee is offline Problem: MailMerge Letter with Some Blank Fields Windows 10 Problem: MailMerge Letter with Some Blank Fields Office 2016
Novice
Problem: MailMerge Letter with Some Blank Fields 		 
Join Date: Sep 2023
Posts: 4
SallyDee is on a distinguished road
Default
Thank you!
Reply With Quote
Reply

Tags
mailmerge, word 16

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem: MailMerge Letter with Some Blank Fields using mailmerge to include a grouped information in a letter Tesla Mail Merge 39 07-01-2022 05:52 PM
using mailmerge to include a grouped information in a letter (2) Tesla Mail Merge 0 09-29-2020 01:30 AM
Problem: MailMerge Letter with Some Blank Fields MailMerge Displaying Blank Fields in Emails constructionjasont Mail Merge 5 06-10-2019 06:13 AM
Problem: MailMerge Letter with Some Blank Fields Mailmerge sends sometimes with text and others in blank yoyoauba Mail Merge 6 01-23-2019 07:53 AM
Problem With Formatting Mailmerge Fields revans611 Mail Merge 0 05-31-2009 06:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 PM.

Contact Us - Privacy Statement - Top

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