| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
MailMerge.CreateShortcut method (Publisher) |
vbapb10.chm6225942 |
|
|
96878925-41ce-4873-931e-d5c05307a94a |
06/08/2019 |
medium |
Creates a shortcut to the file that contains the list of recipients or products for a mail merge publication.
expression.CreateShortcut (FileName)
expression A variable that represents a MailMerge object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| FileName | Required | String | The name of the mailing list or product list file for which the shortcut should be created. |
The CreateShortcut method corresponds to the Save a shortcut to recipient list command in the Mail Merge and Email Merge task panes, and the Save a shortcut to product list command in the Catalog Merge task pane in the Microsoft Publisher user interface.
Mailing list recipient files have the .ols extension (for Microsoft Office List Shortcut).
The following Microsoft Visual Basic for Applications (VBA) macro shows how to use the CreateShortcut method to create a shortcut to a mail-merge recipient list. Before running this macro, ensure that the active document is connected to a data source. If the active document is not already connected to a data source, you can use the OpenDataSource method to make the connection.
Also, before running the code, replace username in the folder path to the saved file with the name of a valid user on your computer, or replace the folder path and file name with a path and file name of your choice.
Note that the folder path used in this example is typical of folder paths in Windows. You must have permission to save files in the folder that you designate.
Public Sub CreateShortcut_Example()
Dim pubMailMerge As Publisher.MailMerge
Set pubMailMerge = ThisDocument.MailMerge
pubMailMerge.CreateShortcut ("C:\Users\username\Documents\My Data Sources\MyRecipientList")
End Sub[!includeSupport and feedback]