Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2020, 02:34 PM
JLOB's Avatar
JLOB JLOB is offline MM persistent request for seperators Windows 10 MM persistent request for seperators Office 2016
Novice
MM persistent request for seperators
 
Join Date: Jun 2018
Location: New England
Posts: 8
JLOB is on a distinguished road
Default MM persistent request for seperators

As much as I’m reluctant to admit it, I’ve recently migrated from Office 2003 to something less archaic. I’m fairly certain it’s 2016, but this new (to me) UI doesn’t appear to have a Help/About spot that would tell what version I’m working with.




Anyway…I have a simple Mail Merge document that takes in a .csv file from Excel and extracts data that feeds a check printer. After converting to .docx, this MM operation now stops and needs to know the field separator, and the record separator each time it’s run.



Does anyone know if there’s a way for me to make my choices either the default for Word, or, better yet, the default for just that document?


I appreciate any input you might provide.


Thanks.


JLOB
Reply With Quote
  #2  
Old 01-28-2020, 04:55 PM
macropod's Avatar
macropod macropod is offline MM persistent request for seperators Windows 7 64bit MM persistent request for seperators Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Are you saving the mailmerge main document after connecting to the data source and defining the separators?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-29-2020, 11:19 AM
JLOB's Avatar
JLOB JLOB is offline MM persistent request for seperators Windows 10 MM persistent request for seperators Office 2016
Novice
MM persistent request for seperators
 
Join Date: Jun 2018
Location: New England
Posts: 8
JLOB is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Are you saving the mailmerge main document after connecting to the data source and defining the separators?

I’m not at all certain that I did it before, and only reasonably certain that I did that today. I certainly tried, but as yet, no joy. Part of the problem is that I built this routine in 2005 when I was, not only younger but infinitely more alert. I have two MM routines, this one and Christmas Card addressing. SHMBO (She who must be obeyed) opted to hand-address the cards this year, so I’m not sure if that one works anymore or not. I’ll worry about that one in November.


I no longer remember how to change the source data, but I apparently did it correctly today. I don’t know how to determine what my main document is, so the change was made by accident. Be nice to know how to do it on a regular basis. As far as the separators, I continue to get the prompts. I can live with it, of course, but would prefer to do it right.


Speaking of which… I’m also getting the warning about allowing SQL code when I invoke the document. I notice that you dealt with that in another response recently, but I believe that dealt with VBA macros, and my problem is a bit different. I’d really like to get rid of that warning. Thoughts?


I’ve attached some screen shots.


Thank you.


JLOB
Attached Images
File Type: jpg Delimiters-1.jpg (133.5 KB, 10 views)
File Type: jpg Delimiters-2.jpg (133.9 KB, 10 views)
File Type: jpg word sql.jpg (104.3 KB, 10 views)
Reply With Quote
  #4  
Old 01-29-2020, 02:10 PM
macropod's Avatar
macropod macropod is offline MM persistent request for seperators Windows 7 64bit MM persistent request for seperators Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Quote:
Originally Posted by JLOB View Post
I’m not at all certain that I did it before, and only reasonably certain that I did that today. I certainly tried, but as yet, no joy.
I would not expect the prompt for delimiters to appear once you've done the basic setup - unless you change the data source or disconnect from it and have to reconnect.
Quote:
Originally Posted by JLOB View Post
I no longer remember how to change the source data, but I apparently did it correctly today. I don’t know how to determine what my main document is, so the change was made by accident.
Unless you've moved the CSV file to a different folder or renamed it, or you're using a different CSV file each year, you shouldn't need to change the source. If indeed you're using a different CSV file each year, try using a generic filename for the current year (e.g. 'Mailing List.csv') in the same folder every time, then renaming/moving it to the 'year' folder it after the mailmerge is done.
Quote:
Originally Posted by JLOB View Post
I’m also getting the warning about allowing SQL code when I invoke the document.
Microsoft introduced that some years ago, to warn users against running documents containing possibly malicious SQL code. If you answer 'No' to the prompt, the document disconnects from the data source. There is a registry edit for suppressing the warning.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-30-2020, 07:03 AM
JLOB's Avatar
JLOB JLOB is offline MM persistent request for seperators Windows 10 MM persistent request for seperators Office 2016
Novice
MM persistent request for seperators
 
Join Date: Jun 2018
Location: New England
Posts: 8
JLOB is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I would not expect the prompt for delimiters to appear once you've done the basic setup - unless you change the data source or disconnect from it and have to reconnect.
Nor would I, but there you have it. The problem I have is when to save the document such that it has the delimiters correct.
Quote:
Originally Posted by macropod View Post
Unless you've moved the CSV file to a different folder or renamed it, or you're using a different CSV file each year, you shouldn't need to change the source. If indeed you're using a different CSV file each year, try using a generic filename for the current year (e.g. 'Mailing List.csv') in the same folder every time, then renaming/moving it to the 'year' folder it after the mailmerge is done.
I use the same input data file name every time. It just has updated data. Years ago, clearly during a moment of creative genius, I named the file csv.csv. Seemed catchy, so I stuck with it!
Quote:
Originally Posted by macropod View Post
Microsoft introduced that some years ago, to warn users against running documents containing possibly malicious SQL code. If you answer 'No' to the prompt, the document disconnects from the data source. There is a registry edit for suppressing the warning.
I'm no stranger to Regedit. Where might I find the code?


Thanks for your continued help. On another note, I hope the fires near you aren't adversely affecting you or your family.


JLOB
Reply With Quote
  #6  
Old 01-30-2020, 02:50 PM
macropod's Avatar
macropod macropod is offline MM persistent request for seperators Windows 7 64bit MM persistent request for seperators Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Quote:
Originally Posted by JLOB View Post
Nor would I, but there you have it. The problem I have is when to save the document such that it has the delimiters correct.
Opening the csv in Excel and saving it as an Excel workbook and using that as the mailmerge data source would certainly overcome that.
Quote:
Originally Posted by JLOB View Post
I'm no stranger to Regedit. Where might I find the code?
See: https://support.microsoft.com/en-my/...command-messag
See also: How to stop a Microsoft Word warning concerning a SQL command when - Microsoft Community
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MM persistent request for seperators Hyperlink request dbalaam Word 2 12-23-2017 04:54 AM
MM persistent request for seperators "Ignore All" Not Persistent After Close and Reopen retexan599 Word 7 10-30-2017 11:23 AM
MM persistent request for seperators Review > Markup. Deselect "Formatting" is not persistent OldGrantonian Word 3 02-06-2014 03:30 AM
Formula Help Request OTPM Excel 16 12-16-2013 01:57 PM
MM persistent request for seperators Formula help request JAMS Excel 2 04-06-2012 10:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 PM.


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