Word Mailmerge Mail Grayed Out
I've created a mail merge Word doc. (using Office XP) , the data source is
an Access query.
Functionality I'm attempting to set up is:
User sets a boolean field [Merge] to true for each person for whom a mail
merge letter is desired.
The query reads address info from the table for each record where [Merge] is
true.
When I open the doc via Word everything is fine, the data is loaded and the
Mail Merge toolbar is active and I can select 'Merge to New Document'.
I want to open this Word doc. from Access and perform the 'Merge to New
Document' rather than have the user work separately in Word. I can open the
doc. successfully but the mailmerge capability isn't recognized.
Here the part of the code with the problem.
If CreateWordObj Then
gobjWord.Visible = True
gobjWord.Documents.Open CurrentProject.Path & ' & DocName
DoEvents
' NEXT LINE FAILS with err.number = 5852 and err.description =
'requested object is not available'
gobjWord.ActiveDocument.MailMerge.Destination = wdSendToNewDocument
gobjWord.ActiveDocument.MailMerge.SuppressBlankLin es = True
gobjWord.ActiveDocument.MailMerge.Execute
gobjWord.ActiveDocument.PrintPreview
gobjWord.Visible = True
End If
If I remove the three lines which reference
gobjWord.ActiveDocument.MailMerge then the document opens in print preview
with the mail merge toolbar greyed out so 'merge to new document' is not
available. It's as though the mail merge capability of the document isn't
recognized.
thx for any insight anyone can offer.
Linda
- Word Mailmerge Mail Grayed Out
- Word Mail Merge Mail Grayed Out Meaning
- Word Mail Merge Mail Grayed Out Word
- Mac Word Mail Merge Email Greyed Out
- Word Mail Merge Mail Grayed Out Images
- Word Mail Merge Grayed Out
Show original message. Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message. In Word 2007, using an existing merge document and Access data, I am unable. To use the 'update labels' command to make changes in the label format. Format a date as “Jul 1, 2020”. ① Click on the merge field of date. The field is grayed out. ② Press Shift+ F9 to expose the field coding. ③ Click in front of ” ” in the field code and enter the date format switch ” @ “. ④ Enter the date format you want such as ” MMM d, yyyy ” after the switch. Enter only M in. Hello, I am trying to find out if it is possible to add tracking when doing a campaign and using mail merge via word into outlook. Once I finish the mail merge, the messages go to my Outlook Outbox, but the HubSpot feature is grayed out, so you can't add it. Is it possible to add the image int.
Was this useful?
To start a Mail Merge, follow these steps: On the ribbon, click the Mailings tab. Click Start Mail Merge. Select Email Messages from the menu, then follow the prompts. (A complete tutorial on mail merge is too lengthy to add here.) Copy and Paste. Go through the usual mail merge steps. Note that the email-address does not need to be in the Word message, but I would recommend to have it as a field in the Excel sheet. In the last step the 'generate e-mail messages' option should not be greyed out anymore. A small window pops open.
Word Mailmerge Mail Grayed Out
Word Mail Merge Mail Grayed Out Meaning
Word Mail Merge Mail Grayed Out Word
Mac Word Mail Merge Email Greyed Out
Share This Page
Word Mail Merge Mail Grayed Out Images
Was this useful?
Related Products
School Meal Management
Word Mail Merge Grayed Out
IRIS FasTrak negates the need for secondary schools to manually manage FSM, as the associated information is fed down automatically by the school’s MIS. Full accounting and reporting options ensure accurate and efficient monitoring of this, with full audit trails.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.